select max(salary) from employ where salary=(select max(salary) from empl

write a query to find the third maximum salary of a
employee.(table:employ col name:salary)

Question Posted / saiprasanna

Answer Posted / saiprasanna

select max(salary) from employ
where salary=(select max(salary) from employ where salary
<(select max(salary) from employ));

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1089

What is auto invoicing? Explain : oracle accounts receivable

1079

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2263

as a technical developer in oracle applications which type errors feced in your experience sofar

2294

What is mrc and what is its use? : oracle accounts receivable

1154

What is an Oracle database Partial Backup?

1129

1. What is PO rate variance gain and loss?

2868

What is chargeback invoice? How do we create it? : oracle accounts receivable

1305

as a technical developer in oracle applications which type errors feced in your experience sofar

2164

Differentiate between transaction type and transaction source? : oracle accounts receivable

1084

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2159

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2483

How to clone the database using RMAN back

2175

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2190

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1099