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 · medium
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 the 2nd highest salary for each department using the DENSE_RANK() function.
Find the error in the provided SQL query.
Find the second-highest salary in the employees table using three different methods.
Find the third-highest salary for each department.
Finding nth Highest Salary within each department
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.