write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
- 7 Answers
- 8903 Views
- I also Faced
- E-Mail Answers
Answer Posted / shrikant
SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal
DESC)
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));
select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);
Select * from EMP_USER A where n-1 = (select count
(distinct (sal)) from EMP_USER B where A.sal<B.sal)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is an Oracle database Full Backup?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is auto invoicing? : oracle accounts receivable
how to write customizations in po
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What Are Cross Validation & Adi?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
