[SQL] solvesql Advent of SQL 2024 10일차

# 링크

• solvesql Advent of SQL 2024: https://solvesql.com/collections/advent-of-sql-2024/

https://solvesql.com/collections/advent-of-sql-2024/

• 10일차 - 최대값을 가진 행 찾기: https://solvesql.com/problems/max-row/

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 ASC

• SELECT id: id 컬럼을 선택한다.
• FROM points: points 테이블에서 데이터를 불러온다. 
• WHERE x = (SELECT MAX(x) FROM points) OR y = (SELECT MAX(y) FROM points): x의 값이 최대값이거나 y의 값이 최대값인 경우만 선택한다.
• ORDER BY id ASC: id 컬럼을 기준으로 오름차순 정렬한다.