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

How many triggers you can have on a table?

993

What is an expression in ms sql server?

1075

What is a trigger and its types?

988

How many categories of functions based their return modes?

1103

How many cores do I need for sql server 2016?

899

Why do you want to join software field as you have done your BE in Electronics?

2144

Explain the properties of subqueries in sql server?

1082

How do you delete a data source?

1007

How do you create a clustered index?

1055

What are the different types of normalization?

1165

Explain forward - only cursors?

1069

What have included columns when we talk about sql server indexing?

1037

What is the stuff and how does it differ from the replace function?

1130

What is SubQuery in SQL Server 2008

1020

What is an identity?

1018