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 the difference between hashed file stage and sequential file stage in relates to datastage server?

1032

What are stand-alone procedures?

905

What integrity rules exist in the dbms?

956

What is raid controller technology?

951

What are the functions of database management system?

901

What is executive plan?

857

What database does facebook use?

903

What is partial key?

986

What are the features of rdbms?

816

What is different keys in dbms?

864

What is database schema in dbms?

1046

What does a database contain?

824

What is the role of database management system?

892

What is Database Management System?

1094

What is db flush?

823