find out the third highest salary?
Answer Posted / bhagayraj
SELECT *
FROM Emp e1
WHERE (2) = (
SELECT COUNT(DISTINCT(e2.Salary))
FROM Emp e2
WHERE e2.Salary > e1.Salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How can windows applications connect to oracle servers?
is there a tool to trace queries, like profiler for sql server?
What is the Tune Query
How do I limit the number of oracle database connections generated by weblogic server?
What is the difference between hot backup and cold backup in oracle?
What is bulk collect in oracle?
Explain oracle left join with an example?
What are the attributes of the cursor?
In the oracle version 9.3.0.5.0, what does each number shows?
What are the uses of a database trigger?
How to load data through external tables?
How to convert dates to characters in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?