select Nth highest salary by using rownum
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 |
Post New Answer View All Answers
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
What are stand-alone procedures?
What integrity rules exist in the dbms?
What is raid controller technology?
What are the functions of database management system?
What is executive plan?
What database does facebook use?
What is partial key?
What are the features of rdbms?
What is different keys in dbms?
What is database schema in dbms?
What does a database contain?
What is the role of database management system?
What is Database Management System?
What is db flush?