write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
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
What are different types of transactions in ar? : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
What Are Cross Validation & Adi?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
can we use lexical perameter in oracle plsql if yes how
Where in the Oracle directory tree structure are audit traces placed?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
what is difference between inner join & nested query or subqueries
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
can u give guidance abt packages of plsql
Explain the process of recievables in oracle financials. : oracle accounts receivable
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks