Answer Posted / venkata
hi, earlier query return sal in asending order and when
duplicate salries are there the earlier highest salary
position returns no rows. I hope this is better query.
select * from (select * from emp order by sal desc)
group by
rownum,empno,ename,job,mgr,hiredate,sal,comm,deptno having
rownum=&n
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can we protect our pl/sql source code?
What are group functions in oracle?
Explain parameter file in oracle.
What to do if the binary spfile is wrong for the default instance?
How do I uninstall oracle 11g?
master table and child table performances and comparisons in Oracle ?
What is the difference between hot backup and cold backup in oracle?
How to convert characters to numbers in oracle?
What are the various types of snapshots ?
How can I create database in oracle?
How to loop through data rows in the implicit cursor?
What are operators in oracle?
What is system tablespace?
Is insert autocommit in oracle?
How to create a stored procedure in oracle?