窗口函数
课程：SQL · 编程练习
SQL编程练习 - 窗口函数
练习内容
-- 使用ROW_NUMBER排名\nSELECT\n name,\n city,\n age,\n ROW_NUMBER() OVER (ORDER BY age DESC) AS rank_num\nFROM users;\n\n-- 按分组排名\nSELECT\n name,\n city,\n age,\n RANK() OVER (PART
课程：SQL · 编程练习
SQL编程练习 - 窗口函数
-- 使用ROW_NUMBER排名\nSELECT\n name,\n city,\n age,\n ROW_NUMBER() OVER (ORDER BY age DESC) AS rank_num\nFROM users;\n\n-- 按分组排名\nSELECT\n name,\n city,\n age,\n RANK() OVER (PART