select Top2(salery)from (select Top3 (salery) from tab1 order by salery D

what is syntex second or third highest salary.

thanks & Regards
Dhirendra sinha

Question Posted / anil tiwari

Answer Posted / anil tiwari

select Top2(salery)from (select Top3 (salery) from tab1
order by salery DESC)order by salery.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How will you monitor replication latency in transactional replication? : sql server replication

1089

What does Master database contains?

1085

Explain the microsoft sql server delete command? : SQL Server Architecture

1012

What is indexing a document?

972

can SSRS reports Cache results?

138

How to generate create table script on an existing table in ms sql server?

1094

What is role playing dimension with two examples? : sql server analysis services, ssas

958

What is federation member?

114

Explain subquery and state its properties?

970

Which rendering formats are affected by the pagesize properties?

134

What are the 2 types of classifications of constraints in the sql server?

1048

What are cursors stored procedures and triggers?

938

How can we delete a table in sql server?

927

What is open database communication (odbc)?

1006

What is de-normalization in sql database administration? Give examples?

929