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

What are the types pl/sql code blocks?

1111

Can we join same table in sql?

1003

how to show all tables with 'mysql'? : Sql dba

1095

How to change the order of columns in Oracle SQL Plus ?

1042

what is acid property in database? : Sql dba

1012

How to handle bulk data?

1300

What is input buffer in sql*plus?

1195

What do you mean by stored procedures?

997

Is a view faster than a stored procedure?

951

Is left join inner or outer?

1006

What is the difference between the sql*loader and import utilities? : aql loader

1013

Explain architecture of sql server notification services?

1041

how can we know the count/number of elements of an array? : Sql dba

1047

Which is better stored procedure or query?

951

What is rename command in sql?

1004