Welcome to my blog!

SQL Interview questions

December 15, 2017 17:57

SQL Interview questions

Get the Total Salary of each Department?

Get the name of employee who having has the highest salary in each department?

Get the 2nd highest salary or nth salary in each department?


ClientID    ClientName

3               Sowrabh Malhotra

4               Saji Mon

6               Sajith Kumar

7               Vipin Job

8               Monoj Kumar


Concatenate the ClientName column like the following?

Sowrabh Malhotra, Saji Mon, Sajith Kumar, Vipin Job, Monoj Kumar

Write a query to pint 1 to 100 in sql server without using loops?


Recent posts