select ename,salary from(select ename,salary from emp order by salary desc)

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / ram

Answer Posted / ram

select ename,salary from(select ename,salary from emp order by salary desc) where rownumber<6

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you use collections in procedure to return the resultset?

2284

Can we rollback after truncate?

1072

Mention what plvcmt and plvrb does in pl/sql?

1200

What is materialized view. What are different methods of refresh?

1438

What program will open a mdb file?

1019

What is sqlcommand?

1071

How do I view tables in sql developer?

1009

How do you optimize a stored procedure in sql?

1015

What is a composite primary key?

1142

How many primary keys can a table have?

1057

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

1167

What is oracle sql called?

973

Is primary key clustered index?

992

How can I speed up sql query?

1007

What does t sql mean?

1001