find out the third highest salary?
Answer Posted / arungkd
Hey dudes ,
i have worked out this question and got the Answer.... here
it is given below...
SELECT min(income) AS salary FROM [user] WHERE income in
(SELECT DISTINCT top 3 income FROM [user] order by income
desc )
Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Explain the use of grant option in imp command.
Explain a segment?
Can we protect our pl/sql source code?
What happens to indexes if you drop a table?
interview questions with answer for cts
How do we get field detail of a table?
How do I uninstall oracle client from windows?
Where do you use decode and case statements?
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 ?
What is the order of defining local variables and sub procedures/functions?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is an Oracle index?
What is the difference between 10g OEM and 11g OEM?
What is a oracle database?
Explain the use of log option in exp command.