If there is no such number, just output null. Code SELECTMAX(num)asnumFROM(SELECTnumFROMnumberGROUPBYnumHAVINGCOUNT(num)=1)ASt # note : havetohasASt
Code: SELECTMAX(num)ASnumFROM(SELECTnumFROMnumberGROUPBYnumHAVINGCOUNT(*)=1)AST;
三、SQL 语句 SELECT MAX(num) AS num FROM ( SELECT num FROM my_numbers GROUP BY num HAVING COUNT(*) = 1 ) AS x;发布于 2020-09-27 09:16 SQL 数据分析 力扣(LeetCode) 赞同1 条评论 分享喜欢收藏申请转载 ...