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

What are the ansi data types supported in oracle?

944

How to define an explicit cursor in oracle?

1034

How can I see all tables in oracle?

1007

What is recovery manager(rman) backup in Oracle?

1183

What is the sid in oracle?

961

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410

What are the restrictions on external table columns?

1052

Define oracle database

1041

What are the common oracle dba tasks?

1141

What is the usage of analyze command in oracle?

1093

What is the difference between substr & instr functions?

1223

Explain oracle 12c new features for developers?

1056

Explain a synonym?

1024

What is oracle sid?

947

How to see free space of each tablespace?

1032