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

How many parts of a pl sql block are optional?

1218

What is the difference between sql and mysql?

1175

What is use of trigger?

986

what is sub-query? : Transact sql

1160

Is vs as in pl sql?

1037

Explain the insert into statements in sql?

1052

What is clause?

1228

Why do we need unique key in a table?

1003

what is msql? : Sql dba

1044

Why we use sql profiler?

1023

Can we perform dml in function?

1131

What does select top 1 do in sql?

1141

How do I write a sql query in pgadmin 4?

1045

how do you control the max size of a heap table? : Sql dba

1023

How do I debug a stored procedure?

1163