select distinct a.sal from employee a where 3=(select count(distinct

Find out the 3rd highest salary?

Question Posted / kaushal kassi

Answer Posted / kaushal kassi

select distinct a.sal
from employee a
where 3=(select count(distinct b.sal)
from employee b
where a.sal<=b.sal)

Is This Answer Correct ?

24 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What are the three pl sql block types?

949

What is mutating table error?

1118

How to display the current date in sql?

1011

How show all rows in sql?

975

Define the select into statement.

997

what is a trigger in mysql? : Sql dba

1071

Is json a nosql?

917

what are ddl statements in mysql? : Sql dba

1114

how to create a test table in your mysql server? : Sql dba

946

Can there be more than one function with a similar name in a pl/sql block?

927

What are the indexing methods?

1003

Can we use pl sql in sql server?

1013

How do you update sql?

915

Are sql database names case sensitive?

937

What are inbuilt functions in sql?

992