최대값을 가진 행 찾기 - solvesql

최대값을 가진 행 찾기

출처 : 최대값을 가진 행 찾기 SolveSQL

내 답안📕

WITH rnk_table AS (
  SELECT id
      , DENSE_RANK() OVER(ORDER BY x DESC) AS 'x_rnk'
      , DENSE_RANK() OVER(ORDER BY y DESC) AS 'y_rnk'
  FROM points
)

SELECT id
FROM rnk_table
WHERE x_rnk = 1
   OR y_rnk = 1
ORDER BY id ASC;

OR

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