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

Answer Posted / ravindra

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6739


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1833


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

686


Why more redos are generated when the oracle database is in begin backup mode?

665


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2053






what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

1804


What is the importance of batch source set up in ar? : oracle accounts receivable

716


Can we modify approve purchase order?if yes what is navigation?

1547


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1614


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

1795


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

734


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

1988


What is autocashrule set? : oracle accounts receivable

736


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1700


What is the difference between conversions and interfaces? : oracle accounts receivable

652