Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where

how to find the second highest salary from emp table?

Question Posted / jyotiprokash

Answer Posted / jyotiprokash

Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where e1.salary<e2.salary)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how to extract a unit value from a date and time? : Sql dba

990

Is sql port 1433 encrypted?

1023

What is user in sql?

1019

What is an escape character in sql?

1024

How many primary keys can a table have?

1006

What is clustered index sql?

984

what are the different index configurations a table can have? : Sql dba

995

How insert into statements in sql?

1072

How subquery works in sql?

1067

Are left and right joins the same?

1085

What is integrity in sql?

1044

what is unique key constraint? : Sql dba

1035

Is pl sql a scripting language?

1030

what are the authentication modes in sql server? : Sql dba

1061

Can a foreign key be null?

1090