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

Answer Posted / sankarapandian

select top 5 salary from employee
order by salary desc

Is This Answer Correct ?    17 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is audit logout in sql profiler?

579


What is flag in sql?

531


What is varchar data type in sql?

510


what are the security recommendations while using mysql? : Sql dba

565


Is join an inner join?

525






what is the difference between delete and truncate statement in sql? : Sql dba

537


How do you take the union of two tables in sql?

509


What are the parameter modes supported by pl/sql?

523


What is procedure explain with program?

541


How do you delete a table?

527


How bulk collect improves performance?

565


What are the different types of constraints?

556


Can you sum a count in sql?

545


How do I start pl sql?

483


What is difference sql and mysql?

520