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 trace file and how is it created in oracle?

1062

what is normalisation?what are its uses?

2274

Why is oracle so popular?

999

Explain mutating triggers.

1034

material view and view disadvantages?

1079

what are archived logs?

2204

How will you differentiate between varchar & varchar2?

1045

What is oracle join syntax?

1005

What is transport network substrate (tns) in oracle?

1047

Explain the difference between sql and oracle?

1082

What are the various oracle database objects?

1148

Can we use bind variables in oracle stored procedure?

953

How to write date and time interval literals in oracle?

1036

How to define a data source name (dsn) in odbc manager?

1035

How to create a new table by selecting rows from another table?

1102