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 are the differences between stored procedure and the dynamic sql?

762

What are the five characteristics of good data?

682

What is meant by indexing files?

778

What is fill factor and pad index?

750

What are various limitations of the views?

792

What is update_statistics command?

765

What is trace flag in sql server?

718

What is nolock hint in sql server 2008

826

Which is the best place or learning center for MS SQL?????In Bangladesh?????

1758

How to convert binary strings into integers in ms sql server?

725

How many tables can be joined in SQL Server?

761

How can you manage sql azure security?

Can the query output be sorted by multiple columns in ms sql server?

728

Why is replication required on the sql server?

770

What do you mean by collation recursive stored procedure?

783