力扣 SQL 619. 只出现一次的最大数字

题目 ：https://leetcode.cn/problems/biggest-single-number/

数据

Create table If Not Exists MyNumbers (num int)

insert into MyNumbers (num) values ('8')
insert into MyNumbers (num) values ('8')
insert into MyNumbers (num) values ('3')
insert into MyNumbers (num) values ('3')
insert into MyNumbers (num) values ('1')
insert into MyNumbers (num) values ('4')
insert into MyNumbers (num) values ('5')
insert into MyNumbers (num) values ('6')

需求

查询最大的单一数字 。当不存在单一数字 ，就查询 null

查询结果 :

| num |
| 6   |

解决

-- 查询单一数字
with t1 as (
    select num
    from MyNumbers
    group by num
    having count(*) = 1
    order by num desc
    limit 1
)
-- 判断是否为 null
select ifnull((select num from t1), null) as num;