select*from(select rownum rn,sal from(select*from emp order by sal desc))wh

Find out the 3rd highest salary?

Question Posted / kumar

Answer Posted / kumar

select*from(select rownum rn,sal from(select*from emp order by sal desc))where rn=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we call procedure in select statement?

522

Can I join the same table twice?

529

How to create a menu in sqlplus or pl/sql?

613

What is linq to sql?

554

Why we use cross join?

543

What are types of joins?

538

How do I add a database to sql?

584

how to use 'mysql' to run sql statements? : Sql dba

539

What are pl sql procedures?

522

what are date and time data types? : Sql dba

542

Explain how to use transactions efficiently : transact sql

529

How sql query is executed?

561

What is group by in sql?

550

Is nosql faster than sql?

544

What is trigger point?

540