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

Find out the 3rd highest salary?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

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

Is This Answer Correct ?

100 Yes

45 No

Please Help Members By Posting Answers For Below Questions

What is a behavioral trigger?

510

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

514

What is trigger explain with example?

542

what are all types of user defined functions? : Sql dba

537

How do I run a query in pl sql developer?

552

what is the difference between truncate and drop statements? : Sql dba

546

How many indexes can be created on a table in sql?

489

Which nosql database is best?

509

Why is sql*loader direct path so fast?

593

What are operators available in sql?

575

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

486

Does asenumerable execute the query?

591

How do I find duplicates in a single column in sql?

524

What are tables in sql?

538

How do I kill a query in postgresql?

541