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
How to assign a tablespace to a users in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
Why do we need oracle client?
What are the attributes of the cursor?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Explain drop constraint oracle?
query optmization techniques and quwry analyser+projects+ppts
How will you differentiate between varchar & varchar2?
How to store only time; not date and time?
Why is oracle used?
How to list all user accounts in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What happens if the imported table already exists?
How to change system global area (sga) in oracle?