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
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
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 the importance of batch source set up in ar? : oracle accounts receivable
Can we modify approve purchase order?if yes what is navigation?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What is autocashrule set? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What is the difference between conversions and interfaces? : oracle accounts receivable