write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
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
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
What is chargeback invoice? How do we create it? : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
which one is currently in used software cmpanies.
can we use lexical perameter in oracle plsql if yes how
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What view would you use to determine free space in a tablespace?
default triggers available for reports
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 an Oracle database Full Backup?
What Are Cross Validation & Adi?
What is the difference between oracle media recovery and crash recovery?