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

Differentiate between pre-select and pre-query?

1049

What is concurrency in oracle?

945

What types of joins are used in writing subqueries?

936

Explain the use of record length option in exp command.

1019

What is the difference between "as" and "is" in an oracle stored procedure?

931

How to connect ms access to oracle servers?

944

In which language oracle has been developed?

1013

What privilege is needed for a user to create indexes in oracle?

961

Is there an oracle sql query that aggregates multiple rows into one row?

930

How to assign data of the deleted row to variables?

1012

What is a private synonym?

1524

How to Truncate Table in Oracle

1088

What is the quickest way to export a table to a flat file?

917

What is blob datatype?

1051

How to drop an index?

904