摘要: leetcode 626 換座位 SELECT (CASE WHEN MOD(id, 2) != 0 AND counts != id THEN id + 1 WHEN MOD(id, 2) != 0 AND counts = id THEN id ELSE id - 1 END) AS id, s 阅读全文
posted @ 2023-05-09 17:57 Carl_ZhangJH 阅读(18) 评论(0) 推荐(0)
摘要: leetcode 619 只出現一次的最大數字 select max(num) as num from ( select num as num from MyNumbers group by num having count(num) = 1 ) as mn select if(count(num) 阅读全文
posted @ 2023-05-09 17:57 Carl_ZhangJH 阅读(20) 评论(0) 推荐(0)