find out the third highest salary?
Answer Posted / husenaiah.b
select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal
Is This Answer Correct ? | 22 Yes | 38 No |
Post New Answer View All Answers
Explain self joins in oracle?
Explain a private synonyms?
what are the default admin accounts in Oracle 10g ?
How do we get field details of a table?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is a nested table?
Explain temporal data types in oracle
What are transaction isolation levels supported by oracle?
How to estimate disk space needed for an export job?
What is the difference between 10g OEM and 11g OEM?
How to delete an existing row from a table in oracle?
What is the use of oracle?
List the parts of a database trigger.
What is the Tune Query
What are operators in oracle?