select * from emp e where &num=(select count(distinct(sal)) from emp

how to find nth highest salary

Question Posted / babu

Answer Posted / babu

select * from emp e where &num=(select count(distinct(sal))
from emp b where b.sal>=e.sal)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is after dml trigger?

1063

Define inner join in sql server joins?

1125

What are the different types of sql server replication? : sql server replication

1369

How to create a view on an existing table in ms sql server?

1194

What are data resources?

965

What is it’s similarity with sql server?

160

How retrieve field names from the table in SQL through JAVA code?

1959

What is function of master database?

117

What is a primary key?

1000

What are the requirements for sql server 2016?

935

Explain table valued parameters in sql server? Why tvp used?

1070

You want to use a perspective in an mdx query. How do you select the perspective?

246

What are sparse columns?

1068

What are the advantages of stored procedure in sql server?

933

Explain datetime2 data type in sal server 2008?

953