Interested to Buy Any Domain ? << Click Here >> for more details...
please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 14855 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / devendra dwivedi
Select * from EmpTbl Where Salary = (Select Max(Salary) from
EmpTbl Where Salary < (Select Max(Salary) from EmpTbl)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What happens to a trigger with multiple affected rows?
What do you understand by SQL*Net?
How does using a separate hard drive for several database objects improves performance right away?
How to populate a table in sql server?
Explain what is the main purpose of having conversation group?
What is order of B+tree?
Explain about Normalization?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is 2nf in normalization?
What does it mean to be in union?
write an SQL query to list the employees who joined in the month of January?
What happens when the SQL Azure database reaches Max Size?
Explain ranking functions?
What is sqlservr.exe - process - sql server (sqlex?press)?
What are the five characteristics of good data?
