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 foreign key? : Sql dba

586


Is sql a dbms?

531


What is a database event trigger?

594


What are the popular database management systems in the it industry?

565


What does select * from mean in sql?

1989






What is a column in a table?

554


Write a sql query to get the third highest salary of an employee from employee_table?

636


How do you remove duplicates without using distinct in sql?

499


Explain how can you save or place your msg in a table?

595


What are the various levels of constraints?

662


How many types of cursors supported in pl/sql?

594


What is count * in sql?

552


What is recursive stored procedure?

601


how can we optimize or increase the speed of a mysql select query? : Sql dba

506


How many sql statements are used?

567