select max(sal) from emp where level=3 connect by prior sal>sal;

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

Question Posted / ravindra

Answer Posted / ravindra

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2324

8. Supporting AP, AR and GL?

2361

Difference between negative and positive adjustments : oracle accounts receivable

1161

1. What is PO rate variance gain and loss?

3009

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2066

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2039

Explain the process of recievables in oracle financials. : oracle accounts receivable

1202

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1223

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1090

can u give guidance abt packages of plsql

2240

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2437

what are the API of GL,PO,AP

2311

can we use lexical perameter in oracle plsql if yes how

2371

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1252

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

3015