Print 3 highest salary

Answer Posted / m gangadhar

select * from (select a.* from employees a order by
a.salary desc) where rownum <= 5

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of mysql?

474


What is the purpose of using timestamp data type?

498


Explain the difference between mysql and mysql interfaces in php?

552


How do I start and stop mysql server?

472


How do I start and stop mysql on windows?

496






What is 'mysqlimport'?

519


How do I stop a mysql service?

504


Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

489


What is mysql gpl?

475


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

511


How do I stop a mysql command?

481


What is an index? How can an index be declared in mysql?

483


What are date and time data types?

497


How to determine the location of the data directory?

496


What is the query to display top 20 rows?

608