select rownum,empno,ename,sal from(select * from emp order by sal desc)gr

select Nth highest salary by using rownum

Question Posted / siva kumar

Answer Posted / siva kumar

select rownum,empno,ename,sal from(select * from emp order by
sal desc)group by rownum,empno,ename,sal having rownum='&n'

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is indexing in database with example?

1020

Describe the difference between data and database administration.

1228

Is this statement true or false? All databases must be in third normal form?

1036

How can you perform pattern matching in sql?

1041

What are the various normalizations in database?

1041

Define view, sequence and index in DBMS.

988

Explain the difference between a primary key and a unique key?

1021

What is natural key?

1045

What are notification services?

1067

Operators used in select statements are?

989

What is information schema in database?

1000

If I use netlib, will I find many other users to network with?

939

What methods is used to commit the changes made in DataSet object?

1100

How to export data from database and import into another?

971

What is the main purpose of normalization?

1090