Interested to Buy Any Domain ? << Click Here >> for more details...
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 the major difference between truncate and delete?
Why packages are used in oracle?
What is hash cluster in oracle?
What is difference between sid and service name in oracle?
Is oracle a relational database?
what is the difference between substr and instr function in oracle?
Explain the use of full option in exp command.
How to rename an existing table?
What is the difference between sharding and replication?
master table and child table performances and comparisons in Oracle ?
What is meant by joins? List out the types of joins.
How to create a new table in oracle?
What is a data dictionary and how can it be created?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
material view and view disadvantages?
