Find Out The Nth Highest Salary SELECT MAX(SAL),LEVEL FROM EMP WHERE

find out the third highest salary?

Question Posted / tejeswara rao potnuru

Answer Posted / tejeswara rao potnuru

Find Out The Nth Highest Salary

SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL=&LEVELNO
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

Is This Answer Correct ?

0 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is tns service name?

1126

Why do we use coalesce function in oracle?

1125

What is the sid in oracle?

968

How many categories of data types?

997

Can select statements be used on views in oracle?

1027

How to get the Installed Oracle Version Information ?

1126

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2188

Which is faster join or subquery in oracle?

995

What is a schema in oracle?

1018

Can you drop an index associated with a unique or primary key constraint?

1022

How to list all user accounts in oracle?

1029

What is the oracle implicit cursor?

1067

How to convert characters to numbers in oracle?

1065

How to write text literals in oracle?

1068

Which environment variables are absolutely critical in order to run the OUI?

2121