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 set transaction?

1044

Why we use sql profiler?

963

What are the various levels of constraints?

1127

What are field types?

1009

What is the difference among union, minus and intersect?

1005

What is the use of prepared statement?

1029

What is the current version of postgresql?

1070

What is natural join in sql?

998

Can sql developer connect to db2?

1056

Difference between global and parameter variables?

1972

What are few of the schema objects that are created using PL/SQL?

1043

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

1084

How do we use distinct statement? What is its use?

1037

What does select top 1 do in sql?

1102

Is sql dba a good career? : SQL DBA

997