Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150706 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 can I create database in oracle?
Explain implicit cursor.
How to create a stored program unit?
How to connect ms access to oracle servers?
what happened to the global index when I truncate the data in one of the partition?
how can we store any pdf file in oracle
How to update a table row with a record?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
please explain.. DB architecture ...
can u plz provide me oca sql dumps please i need them
What is rowid and rownum in oracle?
what are the advantages of running a database in archive log mode?
What do you mean by redo log file mirroring?
Explain the use of show option in imp command.
How do we display rows from the table without duplicates?
