select max(sal) from emp where level=2 connect by prior sal>sal group

how to find the second highest salary from emp table?

Question Posted / radha sri seshu.kolla

select max(sal) from emp where level=2 connect by prior
sal>sal group by level;

Is This Answer Correct ?

17 Yes

22 No

Please Help Members By Posting Answers For Below Questions

How do I view stored procedures?

918

What is the least restrictive isolation level? : Transact sql

999

What is the sql case statement?

954

Is oracle sql free?

928

what is data manipulation language? : Sql dba

949

What is sql trigger example?

1001

How do I truncate a sql log file?

1008

How is use pl and sql?

1004

Is sql difficult?

1107

what is isam? : Sql dba

953

What is compute?

1016

How can we optimize a sql query?

983

What is fmtonly in sql?

1010

Will truncate release space?

890

How do I run a program in pl sql?

953