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
- 11208 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha_gupta
select e.ename,a.sal from (select sal, rownum rnum ,rowid
rid from (select * from emp order by sal desc)) a , emp e
where a.rid= e.rowid
and a.rnum = 3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
as a technical developer in oracle applications which type errors feced in your experience sofar
Where in the Oracle directory tree structure are audit traces placed?
How to clone the database using RMAN back
What do you mean by Oracle MEDIA RECOVERY?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Explain the payment term in ar. : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Explain prerequisites and post activities of oracle database installation
What is mrc and what is its use? : oracle accounts receivable
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?
