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 sql architecture?

1100

What schema means?

939

What is rowid in sql?

1051

How do you create a db file?

1065

Why do we use subquery?

1073

What is the difference between a procedure and a function?

1208

What will you get by the cursor attribute sql%rowcount?

1074

What is data manipulation language?

1227

what is a constraint? : Sql dba

1230

Is join an inner join?

1021

What are database links used for?

1093

what is “go” in t-sql? : Transact sql

1154

What do you know by pl/sql cursors?

1162

What is string join?

1023

How do I view a table in sql?

1040