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 erd?

586

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

1558

Explain environment of openedge?

549

Who has the largest database?

474

Explain the functionality of dml compiler.

599

How many types of users in dbms?

449

What is database url?

518

How to recreate the index on a firebird table?

486

What is 'cross join'? Or what is cartesian product?

533

What are stand-alone procedures?

542

What are the types of database management system?

528

Define entity.

558

Explain the term entity type in dbms?

515

What do you understand by data independence? What are its two types?

622

What is the Structural difference between bitmap and b-tree index ?

546