SQL 高级测验
子查询、窗口函数、CTE、索引和高级 SQL 技术。
Question 1 of 7
Question 1 of 7sql
窗口函数用什么来定义工作行集？
sql
SELECT name, salary,
RANK() OVER (PARTITION BY dept ORDER BY salary DESC) AS rnk
FROM employeesadvanced
子查询、窗口函数、CTE、索引和高级 SQL 技术。
SELECT name, salary,
RANK() OVER (PARTITION BY dept ORDER BY salary DESC) AS rnk
FROM employees