Code: SELECTMAX(num)ASnumFROM(SELECTnumFROMnumberGROUPBYnumHAVINGCOUNT(*)=1)AST;
If there is no such number, just output null. Code SELECTMAX(num)asnumFROM(SELECTnumFROMnumberGROUPBYnumHAVINGCOUNT(num)=1)ASt # note : havetohasASt
619. Biggest Single Number shanshant 来自专栏 · shanshant数据分析专栏 一、表信息 表my_numbers 在 num 列中包含许多数字,包括重复的数字。 Table my_numbers contains many numbers in column num including duplicated ones. Table: my_numbers 二、题目信息 查找最大的数字,该数字只出现一次。 注意:如果...
619. Biggest Single Number # Write your MySQL query statement below SELECT MAX(t.num) AS num FROM (SELECT num FROM number GROUP BY num HAVING COUNT(num) = 1) t ;