Given an `employees` table with columns `emp_id`, `emp_name`, `designation`, and `salary`, write a SQL query using window functions to find the top 10 highest-paid employees within each designation.
You've read your 3 free write-ups
Sign up free to keep reading. Your account opens the first 10 questions of every company.