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

Explain the uses of control file.

773

How do you write a subquery?

692

What is user in sql?

761

What is the benefit of foreign key?

714

Is oracle and sql same?

745

what is online transaction processing (oltp)? : Sql dba

713

What are string functions in sql?

885

how many sql ddl commands are supported by 'mysql'? : Sql dba

700

What does pragma mean?

711

What is sql used for?

856

Explain the working of primary key?

836

What is the difference between a subquery and a join?

699

Do foreign keys improve performance?

746

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1156

What is difference between sql and mysql?

748