SQL Practice Logo

SQLPractice Online

Level 3 - IntermediateFill-in-the-Blank Questions

Fill In Window Ranking Clause

Complete the query to rank salary by department (highest first). SELECT employee_id, department_id, salary, _____( ) OVER (_____ department_id _____ salary _____) AS dept_rank FROM employees;