Must Know SQL Questions for Your Upcoming Interviews
Apurva Suke
1.Find the second high salary employee from Employee table consist of EmpID, Name,Salary Columns.Select TOP 1 * from(Select TOP 2 * from Emp.EmployeeOrder by Salary desc) as AOrder by Salary…
1.Find the second high salary employee from Employee table consist of EmpID, Name,Salary Columns.Select TOP 1 * from(Select TOP 2 * from Emp.EmployeeOrder by Salary desc) as AOrder by Salary…