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

Can a view be mutating? If yes, then how?

1028

How to read/write files from pl/sql?

1036

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1227

what is view? : Sql dba

961

Mention what plvcmt and plvrb does in pl/sql?

1143

What is cold data?

963

What are the benefits of stored procedures?

1074

Can we create index on primary key?

970

How do I audit the sql sent to the server?

1010

what is 'mysqlcheck'? : Sql dba

1015

Name some usages of database trigger?

1021

Can you have more than one trigger on a table?

1003

Is crud a cuss word?

1036

what is a trigger? : Sql dba

1030

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120