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


Please Help Members By Posting Answers For Below Questions

Explain the use of grant option in imp command.

578


Explain a segment?

621


Can we protect our pl/sql source code?

580


What happens to indexes if you drop a table?

701


interview questions with answer for cts

2090






How do we get field detail of a table?

627


How do I uninstall oracle client from windows?

537


Where do you use decode and case statements?

556


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 ?

2050


What is the order of defining local variables and sub procedures/functions?

600


how to do daily transactions with out sql* loader control file regesterd in apps?

1224


What is an Oracle index?

1179


What is the difference between 10g OEM and 11g OEM?

563


What is a oracle database?

609


Explain the use of log option in exp command.

534