select salery from (select salery from emp order by salery desc) where ro

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

Question Posted / kishore

Answer Posted / kishore

select salery from (select salery from
emp order by salery desc) where rownum <=5 ;

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the largest value that can be stored in a byte data field?

958

What is set transaction?

990

How many types of indexes are there in sql?

935

What is asqueryable?

905

What are the different sql commands?

1003

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3010

Is oracel sql developer written in java?

1060

Which version of sql do I have?

1000

What programs use sql?

944

what is a database transaction? : Sql dba

1108

Give the order of sql select?

1089

How do I view an execution plan in sql?

924

What is a data definition language?

1029

What is error ora-01000: maximum open cursors exceeded

1065

Why do we use sqlite?

919