JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
Real questions from top companies
Find 3rd Highest Salary
Find Employees with Maximum Salary in Each Department
Find average salary by department, max average salary, and list of employees for the max salary department.
Find average salary for each manager – Assume a table with manager_id and employee_salary
Find each student's previous year's scores using the LAG function.
Find employees who earn the third-highest salary.
Find non-common records in two tables (SQL EXCEPT or NOT IN)
Find the 2nd highest salary for each department using the DENSE_RANK() function.
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.