select num,count(1) c
from T0924
GROUP BY num
HAVING c =1
ORDER BY num desc
limit 0,1
select max(num)
from (select num, count(rn) count_rn
from (select num, row_number() over (partition by num order by num) rn from T0924) a
group by num) a
where count_rn = 1