write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
- 7 Answers
- 8942 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
What is an Oracle database Full Backup?
key flexfield structure
What is the sql query to find the employee who has Nth maximum salary?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
How do you create a credit note against an invoice? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is the mandatory setup in cyclecount ?
What is auto invoicing? Explain : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
Explain the payment term in ar. : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Explain the use of table functions.
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
