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
Can we create trigger on materialized view in oracle?
What is the difference between I and G in Oracle?
How to invoke the data pump import utility?
What are the differences between number and binary_float in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is the difference between a user and a schema in oracle?
How to write date and time interval literals in oracle?
What is system global area (sga) in oracle?
What do you mean by merge in oracle?
What is oracle datasource?
What operating systems are supported by oracle database 10g xe?
What privilege is needed for a user to create views in oracle?
How to drop a stored procedure in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to create a new oracle data file?