select * from emp where sal=(select max(sal) from emp where sal not in(se

how to find the second highest salary from emp table?

Question Posted / sankar

Answer Posted / sankar

select * from emp where sal=(select max(sal) from emp where
sal not in(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between rename and alias?

1344

What is using in sql?

1094

What is the max nvarchar size?

982

Why triggers are used?

990

What is a left join?

955

How is data stored on a disk?

1037

What are the different type of joins in sql?

956

What is the source code of a program?

1070

Is subquery faster than join?

1014

How can you load microsoft excel data into oracle? : aql loader

1174

Does view contain data?

1037

How many tables can a sql database have?

978

What is sql rowcount?

1023

What are the set operators in sql?

1073

how to use like conditions? : Sql dba

1110