sql/Advent of SQL 2024

SQL 문제 풀이 챌린지(10/25) - 최대값을 가진 행 찾기

gooreumsea 2024. 12. 11. 15:13

저작권 문제로 인해, 직접 작성한 쿼리문만 공개.

 

 

10. 최대값을 가진 행 찾기

https://solvesql.com/problems/max-row/

SELECT id
FROM points
WHERE x = (SELECT MAX(x) FROM points)
OR y = (SELECT MAX(y) FROM points)
ORDER BY id