please tell me the query to get details of the employee
having the second largest salary
Answer Posted / shivangi
Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What does nvl stand for?
If a table does not have a unique index, can a cursor be opened on it?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is the difference between varchar and nvarchar datatypes?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are page splits?
What is the impact on other user sessions when creating indexes?
How to retrieve error messages using mssql_get_last_message()?
Explain four layers of abstraction microsoft architectured?
Why use “nolock” in sql server?
What is the need for group functions in sql?
Tell me something about security and sql azure?
Can we use having clause without group by?
What is plan freezing?
What is ms sql server service broker?