SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL=&LEVEL CONNECT BY PRIOR SA

how to find the n'th highest salary from emp ?

Question Posted / venki

Answer Posted / venki

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a subquery?

615

What does sharding mean?

539

How to define an anonymous block?

618

Is insert autocommit in oracle?

606

what are archived logs?

1717

What is a server parameter file in oracle?

594

Describe varray?

591

How will you identify oracle database software release?

527

Difference between open_form and call_form in oracle.

681

How to drop an existing view in oracle?

571

How to add a new column to an existing table in oracle?

588

When do you get a .pll extension in oracle? Explain its importance

574

How to create additional tablespaces for an new database?

572

Can a formula column referred to columns in higher group ?

2088

What is tns name?

547