select sal from (select sal from(Select distinct sal from EMP order by sal

how to find nth highest salary

Question Posted / ravindra babu

Answer Posted / ravindra babu

select sal from (select sal from(Select distinct sal from
EMP order by sal desc)Where rownum <=2 order by sal asc)
Where rownum=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Do you know what is similarity and difference between truncate and delete in sql?

1010

What are the advantages dts has over bcp?

1001

What are the tool windows in sql server management studio? : sql server management studio

1081

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2225

Explain about sql server login?

1092

What are different types of statement?

1019

What is a covered index?

941

How to create function without parameter in sql server?

1059

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2365

System variable and temporary variables

2255

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1040

What you can do to delete a table without the delete trigger firing?

973

Differentiate between a having clause and a where clause.

965

How to return the date part only from a sql server datetime datatype?

1106

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

1113