select top 5 salary from employee order by salary desc

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

Question Posted / sankarapandian

Answer Posted / sankarapandian

select top 5 salary from employee
order by salary desc

Is This Answer Correct ?

17 Yes

8 No

Please Help Members By Posting Answers For Below Questions

what is collation? : Sql dba

1242

Does group by remove duplicates?

1120

Is inner join faster than left join?

1287

how many tables will create when we create table, what are they? : Sql dba

1155

what is dbms? : Sql dba

1070

how to use regular expression in pattern match conditions? : Sql dba

1125

Do we need to rebuild index after truncate?

1152

Can delete statement be rollbacked?

1065

what is schema? : Sql dba

1163

Is primary key always clustered index?

1101

If a cursor is open, how can we find in a pl/sql block?

1252

what are the advantages of sql ? : Sql dba

1154

how to start mysql server? : Sql dba

1279

What is the current version of postgresql?

1188

How do I remove duplicates in two columns?

1202