select * from emp where sal = (select max(sal) from emp where sal <>

how to find the second highest salary from emp table?

Question Posted / vinod dubey

Answer Posted / vinod dubey

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

it will defiantly work

best of luck

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is integrity in sql?

1047

How do I find duplicates in sql?

930

What is union?

1171

How do I run a sql trace?

960

What is embedded sql what are its advantages?

1043

How do you optimize a query?

1003

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

Where is all the data on the internet stored?

1014

What is user in sql?

1025

What are sql built in functions?

937

Why do we create stored procedures & functions in pl/sql and how are they different?

950

Can ddl statements be used in pl/sql?

1145

What is the usage of nvl function?

1040

What are tables and fields?

1034

What is numeric function sql?

1064