select * from tablename.aliasname where nth=select count(sal) from tablena

how to find nth highest salary

Question Posted / udathayadav

Answer Posted / udathayadav

select * from tablename.aliasname where nth=select
count(sal) from tablename where aliasname.sal<=sal

Is This Answer Correct ?

38 Yes

26 No

Please Help Members By Posting Answers For Below Questions

Can you tell me some of the common replication dmv's and their use? : sql server replication

928

Define self join?

1032

What is a hint?

993

What is ssrs?

129

How to execute a sql statement using odbc_exec()?

1144

What is the boxing and unboxing concept in .net?

919

Is it possible to have clustered index on separate drive from original table location?

967

Can we call future method from queueable?

1051

In which format does an image save in SQL Server database ?

1002

How to get a list of columns in a view using the "sp_columns" stored procedure?

1042

What are the advantages of the mirroring?

1094

How much memory that we are using in Logshipping Concept?

1797

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4386

How do I start sql server 2017?

942

Describe the left outer join & right outer join. : sql server database administration

996