SELECT MAX( Sal ), LEVEL FROM Emp WHERE LEVEl = &Givelevelno

how to find the second highest salary in a given table????

Question Posted / ajit nayak

Answer Posted / ajit nayak

SELECT MAX( Sal ), LEVEL
FROM Emp
WHERE LEVEl = &Givelevelno
CONNECT BY PRIOR Sal > Sal
GROUP BY LEVEL;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3246

Explain the use of indexes option in imp command.

1262

What is the usage of synonyms?

1215

Can group functions be used in the order by clause in oracle?

1044

What is the usage of analyze command in oracle?

1141

How do you find current date and time in oracle?

1099

how to clone 9i Database on to 10g Database.

2384

How are extents allocated to a segment?

1181

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2408

How to create a testing table in oracle?

1032

How does the on-delete-cascade statement work?

1163

Explain the use of grant option in exp command.

1109

How to count duplicated values in a column in oracle?

1105

What is the difference between pre-select and pre-query?

1302

What does sharding mean?

1053