find out the third highest salary?
Answer Posted / anirban mitra
SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN (SELECT MAX(SAL)
FROM EMP UNION SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN
(SELECT MAX(SAL) FROM EMP))
Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
Can sub procedure/function be called recursively?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is archive log in Oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to initialize variables with default values?
How to rollback the current transaction in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is the difference between substr and instr?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is a data dictionary and how can it be created?
What is the difference between Delete, Truncate and Drop in Oracle?
Give the various rollback segment states.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?