题目来源:
leetcode题目,网址:619. 只出现一次的最大数字 - 力扣(LeetCode)
解题思路:
首先利用group by 找出只出现一次的数字,然后找出其中的最大者。
解题代码:
# Write your MySQL query statement below
select max(num) as num
from (select *
from MyNumbers
group by num
having count(num)=1) as a
总结:
group by ... having... 以 group by 后面的字段聚合,按照 having 后面的筛选。