select top 1 sal from (select top n sal from tbl

how to find nth highest salary

Question Posted / kunal gupta

Answer Posted / kunal gupta

select top 1 sal from (select top n sal from tbl_master
group by sal order by sal desc)m order by sal

This answer is easiest and 100% tested

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is table level trigger?

1058

What is your recommendation for a query running very slow? : sql server database administration

1113

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

2001

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1385

how can you attach more than 20 ldf files in sql server

2052

What is default constraint?

1054

How to select true false based on column value in sql server?

1084

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1080

Which Model uses the SET concept

1045

What are the main sources of data?

1148

What are the properties of the transaction?

1052

How to define the name and server for a new dsn?

1197

Can another user execute your local temporary stored procedures?

1027

What are different backups available in sql server?

1157

Describe in brief sql server monitoring ways.

1103