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

Can delete statement be rollbacked?

1065

what is dbms? : Sql dba

1072

define sql insert statement ? : Sql dba

1110

Can we use distinct and group by together?

1148

What is your daily office routine?

2353

How do I remove duplicates in two columns?

1203

what is bcp? When does it used? : Sql dba

1065

what is collation? : Sql dba

1242

what is schema? : Sql dba

1165

Is primary key always clustered index?

1101

Is inner join faster than left join?

1289

What is the best sql course?

1064

What is the current version of sql?

1106

what are the advantages of sql ? : Sql dba

1154

Do we need to rebuild index after truncate?

1156