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 一、表信息 表my_numbers 在 num 列中包含许多数字,包括重复的数字。 Table my_numbers contains many numbers in column num including duplicated ones. Table: my_numbers 二、题目信息 查找最大的数字,该数字只出现一次。 注意:如果没有这样的数字,则仅输出 null。
LeetCode 619. Biggest Single Number Table number contains many numbers in column num including duplicated ones. Can you write a SQL query to find the biggest number, which only appears once. For the sample data above...619. Biggest Single Number(必看) Null, max()/min() 用法 Table ...
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 ;