select max(sal) from employee where sal not in(select max(sal) from employ

how to find the second highest salary from emp table?

Question Posted / vikas naik

Answer Posted / vikas naik

select max(sal) from employee where sal not in(select
max(sal) from employee);

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a temporal data type?

1045

What are pl sql procedures?

1023

What is spool?

1050

Are stored procedures compiled?

917

What view means?

975

What are the parts of a sql statement?

1085

What is rownum?

977

Is sql a oracle?

976

What is function and procedure in pl sql?

1039

What are the two virtual tables available at the time of database trigger execution?

1222

What is pivot in sql?

909

What is over () in sql?

953

Explain the working of primary key?

1092

define join and explain different type of joins? : Sql dba

950

How can the performance of a trigger be improved?

1040