SQL | SOVESQL 2024 🎄: Day 10. 최대값을 가진 행 찾기

Day 10. 최대값을 가진 행 찾기

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

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

❗WHERE 절에 서브쿼리 사용해서 최대 X값, 최대 Y값을 필터링