select q.sal from emp q where 3=(select distinct(count(b.sal))

Find out the 3rd highest salary?

Question Posted / srikanth

Answer Posted / srikanth

select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)

Is This Answer Correct ?

17 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What does pl sql developer do?

901

explain the difference between delete , truncate and drop commands? : Sql dba

1045

What are the types of triggers in sql?

1043

Is truncate ddl or dml?

957

Is oracle and sql same?

968

What is sql character function?

1030

How to run sql*plus commands in sql developer?

1107

What is use of trigger?

890

How do sql triggers work?

1002

What is sap sql?

947

Is sqlite free?

925

Enlist the advantages of sql.

960

Explain the significance of the & and && operators in pl sql.

972

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

951

What is sql mysql pl sql oracle?

1045