from the table display the 2nd highest salary?
and also the least 2nd salay?
Answer Posted / sridhar sahoo
select distinct top 1 salary from payroll..emp where salary
in(select distinct top 3 salary from payroll..emp order by
salary desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What language is sql server written in?
Is mysql the same as sql server?
Explain the truncate command?
What are the different types of indexes?
What is the difference between grant and with grant while giving permissions to the user?
List out a number of the wants to setup a SQL Server failover cluster?
What is an example of a primary key?
Explain the concept of view and Types of views in SQL server?
What are the different types of backups avaialabe in sql server 2005?
Where cross join is used?
What is the use of builtinadministrators group in sql server? : sql server security
What is filter index?
How to list all stored procedures in the current database using ms sql server?
Why we use the openxml clause?
How do I find the sql server database version?