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 are dml statements in oracle?
Can you assign multiple query result rows to a variable?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How do I escape a reserved word in oracle?
How to build data dictionary view an new database?
Explain what are the advantages of views?
How to view the tablespaces in the current database?
How to get last row id?
What are the restrictions on external table columns?
What is the difference between postgresql and oracle?
How to declare a local variable?
Explain the function of optimizer in oracle?
How to define a sub function?
What is the meaning of recursive hints in oracle?
How to use subqueries with the in operator using oracle?