Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
- 7 Answers
- 11611 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha_gupta
select ename,sal from (select rownum rnum ,rowid rid from
emp order by sal desc) a , emp e
where a.rnum = 4
and a.rid= e.rowid
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Difference between transaction type and transaction sources. : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
How many segment are present in Oracle Manufacturing
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is supporting issues GL AP and AR?
Difference between negative and positive adjustments : oracle accounts receivable
What is Tax Categories?
What is the sql query to find the employee who has Nth maximum salary?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
Explain prerequisites and post activities of oracle database installation
