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

What is raid? : SQL Server Architecture

1183

Explain difference between control flow and data flow?

970

what is the information that can be stored inside a bit column? : Sql server database administration

969

how can you check the level of fragmentation on a table? : Sql server administration

985

How do I view a stored procedure in sql server?

984

what is a self join? : Sql server database administration

1046

How to access the inserted record of an event?

1049

How to delete multiple rows with one delete statement in ms sql server?

1028

Tell me what is de-normalization and what are some of the examples of it?

1054

What happens if you insert a duplicate key for the primary key column in ms sql server?

978

What is RAID? What are the different types of RAID configurations?

1136

What is full outer join in sql server joins?

1073

Mention the uses of stored procedures.

973

Tell me what do we need queues in sql service broker?

996

What is the command used to recompile the stored procedure at run time?

1083