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

State all possible different index configurations a table can possibly have?

1104

State any two functions of oracle?

1099

How to convert dates to characters in oracle?

1093

Can you assign multiple query result rows to a variable?

1039

Describe an oracle table?

1100

How can you merge two tables in oracle?

1049

Difference between varchar and varchar2 data types?

1262

What operating systems are supported by oracle database 10g xe?

1090

What is a synonym? What are its various types?

1175

How to lock and unlock a user account in oracle?

1163

What is PL/SQL ?

2220

Explain oracle’s server parameter file.

1041

What is a table index?

1171

What are the attributes of the cursor?

1060

How to list all indexes in your schema?

1143