← Nagarro questions
CodingReported in a candidate post, Oct 2024

Top 10 Amps From Each Designation SQL Query

Filed under Nagarro

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.

Related Nagarro questions

Collected from public candidate posts and coding forums. Updated Nov 2026.