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
What is object data modeling?
What are operators in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
what is reindexing?
what are bitmap indexes? How does they work?
What is an oracle tablespace?
How to apply filtering criteria at group level in oracle?
How translate command is different from replace?
What is an oracle transaction?
What happens to indexes if you drop a table?
What is translate in oracle?
Is truncate autocommit in oracle?
Explain the characteristics of oracle dba?
How to drop a stored procedure in oracle?
Calculate difference between 2 date / times in oracle sql?