SQL/LeetCode

[LeetCode] 619. Biggest Single Number

yeyeyep 2025. 2. 18. 16:31

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH num_cnt AS (
    SELECT *
        , COUNT(*) OVER (PARTITION BY num) AS cnt
    FROM MyNumbers
)

SELECT MAX(num) AS num
FROM num_cnt
WHERE cnt = 1

 

 

'SQL > LeetCode' 카테고리의 다른 글

[LeetCode] 626. Exchange Seats  (0) 2025.02.18
[LeetCode] 620. Not Boring Movies  (0) 2025.02.18
[LeetCode] 610. Triangle Judgement  (0) 2025.02.18
[LeetCode] 608. Tree Node  (0) 2025.02.18
[LeetCode] 607. Sales Person  (0) 2025.02.18