SELECT * FROM EMP e where 3=(select count(*) from emp

find the third highest salary?

Question Posted / chandra sekhar

Answer Posted / chandra sekhar

SELECT * FROM EMP e
where 3=(select count(*) from emp
where e.sal<=sal)

Using this correlated subquery we can easily get any one

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

934

Does oracle use sql?

907

How to find 3rd highest salary of an employee from the employee table in sql?

1060

what are the different type of normalization? : Sql dba

1012

How exception is different from error?

1002

What is the usage of sql functions?

1128

How many types of literals are available in pl sql?

1096

Which join condition can be specified using on clause?

938

what is sql profiler? : Sql dba

1023

Is sqlite good enough for production?

981

What is sql character function?

1051

Can we change the table name in sql?

925

Can one improve the performance of sql*loader? : aql loader

1026

What are literals in sql server?

1139

How do you declare a constant?

945