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

Is sqlexception checked or unchecked?

920

What are aggregate functions in sql?

1090

How subquery works in sql?

997

Can we call dml statement in function?

980

How is a PL/SQL code compiled?

1172

What is a crud api?

903

how mysql optimizes distinct? : Sql dba

1001

What is full form of rtm?

953

What is the reports view in oracle sql developer?

928

What is AUTH_ID and AUTH_USER in pl/sql ?

2142

tell us something about heap tables. : Sql dba

1049

What are the types of subqueries?

1018

What is mutating sql table?

1041

Does sql support programming?

1008

What is rank function in sql?

965