AgreeYa Solutions Senior Software Engineer Interview Questions and Answers

SQL query to fetch duplicates

• Use GROUP BY and HAVING clause to identify duplicates

• Select columns to be checked for duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

SQL query to fetch nth highest Salary

• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary

• Consider handling cases where there might be ties for the nth highest salary