Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147616 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / venkatranjith e
Hi All,
This query will give you the o/p.
Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)
n = 3 , to display 3rd largest salary.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to synchronize 2 schema's objects?
How to assign values to variables?
Explain how you would restore a database using RMAN to Point in Time?
What is pragma autonomous transaction in oracle?
How to write a query with an inner join in oracle?
how may join possible between (requisition with purchase order)
What is the exact use of Collections?
How to rename an existing table?
State some uses of redo log files?
When do I need to use a semicolon vs a slash in oracle sql?
How to connect ms access to oracle servers?
What is an index associated with a constraint?
What is the difference between primary key and unique key and foreign key in oracle?
How to get the Installed Oracle Version Information ?
what is dynamic SGA and static SGA
