select distinct top 1 salary from payroll..emp where salary in(select dis

from the table display the 2nd highest salary?
and also the least 2nd salay?

Question Posted / sridhar sahoo

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

Please Help Members By Posting Answers For Below Questions

What language is sql server written in?

989

Is mysql the same as sql server?

914

Explain the truncate command?

920

What are the different types of indexes?

1049

What is the difference between grant and with grant while giving permissions to the user?

900

List out a number of the wants to setup a SQL Server failover cluster?

1010

What is an example of a primary key?

915

Explain the concept of view and Types of views in SQL server?

944

What are the different types of backups avaialabe in sql server 2005?

972

Where cross join is used?

905

What is the use of builtinadministrators group in sql server? : sql server security

971

What is filter index?

910

How to list all stored procedures in the current database using ms sql server?

1058

Why we use the openxml clause?

956

How do I find the sql server database version?

942