To find Top 3 max Sal.... to put any number on the place of 3 to find nth

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / kumar amit ranjan

Answer Posted / kumar amit ranjan

To find Top 3 max Sal.... to put any number on the place of
3 to find nth max sal...

select top 3 sal from emp order by sal desc

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is an index. What are the types?

1165

What is indexing a document?

1093

How to define and use table alias names in ms sql server?

1214

How would we use distinct statement? What is its use?

1125

What are various limitations of the views?

1093

When is update_statistics command used?

1089

What are the restrictions that views have to follow?

1031

Define a cross join?

1084

What is self contained scalar sub query?

1019

How to specify the collation for a character data type in ms sql server?

1089

What are the five major components of a dbms?

962

What is the difference between the 2 operating modes of database mirroring?

1166

What is a fill factor?

1141

Explain the functionalities that views support?

1162

Can you type more than one query in the query editor screen at the same time?

1070