只出现一次的最大数字

题目描述

2、解题思路

首先对每个数字出现次数统计
select num,count(num) from my_numbers group by num having count(num)=1

然后找出最大的数字
select max(num) as num

语法

SELECT
	max(num) AS num 
FROM(
	select num,
	count (num)
FROM
	my_numbers
GROUP BY
	num
HAVING
	cout (num) = 1) a