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

What is the use of sqlerrd 3?

941

How subquery works in sql?

1067

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1115

What is a sql driver?

995

How many sql statements are used?

1007

what is the difference between sql and t-sql? : Transact sql

1084

What is attribute indicator in pl sql?

1011

What is server name sql?

1141

what is error ora-03113: end-of-file on communication channel?

1159

What is a constraint?

1019

How do I run a script in sql developer?

944

What does (*) mean in sql?

948

What are sql ddl commands?

1086

What are the sql aggregate functions?

1122

What is a boolean in sql?

977