select sal from emp where sal=(select max(sal) from emp where sal<(sele

how to find the second highest salary from emp table?

Question Posted / anuj maheshwari

Answer Posted / anuj maheshwari

select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));

Is This Answer Correct ?

34 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Which type of cursor is used to execute the dml statement?

995

What is composite data type in pl sql?

1170

What is the purpose of cursors in pl/sql?

1204

Can we insert data into materialized view?

993

How many types of cursors are available in pl/sql?

1167

What is pl/sql table? Why it is used?

1080

what is uncommittable transactions? : Transact sql

1038

What is rollback?

1186

What are the parts of a sql statement?

1146

How do I count rows in sql query?

1042

What is sqlca in db2?

1037

What are different sql data types?

1129

Can we call procedure in select statement?

1113

Which join is default?

1016

How do you modify a column in sql?

1054