GitHub

9_window_functions.sql.sql

ROW_NUMBER() OVER(PARTITION BY dept_name ORDER BY salary) AS rn, --(123456) RANK() OVER(PARTITION BY dept_name ORDER BY salary) AS r, --(123446) DENSE_RANK() OVER(PARTITION BY dept_name ORDER BY ...