SQL Queries - Real time frequently asked by Companies - PART 2/5 - Questions

I have started posting a series of sqlserver queries that are asked in interviews. This can be a great start of practising the queries.

This is the second part of the series. I suggest you to view the PART 1 before coming to this section as it is a bit complex than the other one.

I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

1.        Write a query to display nth highest salary of an employee?

2.        Write a query to print numbers from 1 to 10 using CTE?

3.        Write a query to find all employees whose salary is higher than their department average salary?

4.        Write a query to delete duplicate rows from a table?

5.        Write a query to get top 3 sales person information who has sold maximum order value?