select * from emp e1 where 2 = ( select count(distinct sal)

how to get second highest salary in SQL(as/4000

Question Posted / raji_4u

Answer Posted / raji_4u

select *
from emp e1
where 2 = ( select count(distinct sal)
from emp e2
where e1.sal <= e2.sal
)

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

explain what is mysql? : Sql dba

1030

What is the difference between a primary key and a clustered index?

929

What is rtm stands for?

1020

what are rollup and cube in t-sql? : Transact sql

1047

How do I run a sql query in pgadmin 4?

904

How to use boolean type in select statement?

993

What is a table?

955

What is lookup table in sql?

980

How to load data with sql*loader?

995

Is it possible to read/write files to-and-from PL/SQL?

1035

Explain cursor types?

955

How to display the records between two range in Oracle SQL Plus?

1098

how to use 'mysql' to run sql statements? : Sql dba

983

When sql appeared?

1023

What are different types of statements supported by sql?

1096