LeetCode 619.只出现一次的最大数字

数据准备

Create table If Not Exists MyNumbers (num int);
Truncate table MyNumbers;
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');

输入

输出

select *,
       count(num) as cnt
from MyNumbers
group by num
having count(num)=1
order by num desc
limit 1;

-- 查询出所需要的信息
select num
from MyNumbers
group by num
having count(num)=1
order by num desc
limit 1;