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
