select min(salary) from salary where salary in(select top 3 salary from sa

what is syntex second or third highest salary.

thanks & Regards
Dhirendra sinha

Question Posted / praveen singh

Answer Posted / praveen singh

select min(salary) from salary where salary in(select top 3
salary from salary order by salary desc)

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Do you know hot add cpu in sql server 2008?

908

Describe triggers features and limitations?

942

What are the different types of sub-queries?

1009

How to get the query of a table in sql server?

865

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1102

How do you Implement SSIS Packages in your Project?

1880

explain how to create a new schema in a database? : Sql server database administration

1078

what is an extended stored procedure? : Sql server database administration

1009

How to create a dml trigger using create trigger statements?

983

What is difference between Datepart() and Datename() in SqlServer?

1171

What is the most common type of join?

933

How to retrieve error messages using odbc_errormsg()?

1006

Explain various On-Delete options in a DB table. Which is the default option?

1419

What is the difference between osql and query analyzer?

950

Explain differences between web edition and business edition?

119