Print 3 highest salary

Answer Posted / lokesh das

Using a single query not sub-query

SELECT * FROM `employee` ORDER BY salary DESC LIMIT 2, 1

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which statement is used in a select query for partial matching?

610


How to create trigger in mysql workbench?

541


What is clob datatype?

476


What is the query to display top 20 rows?

609


What is a mysql view?

461






What can I do with mysql?

503


How do you select a table?

481


What is blob storage?

494


Is foreign key indexed mysql?

470


Can not connect to mysql server 10060?

497


How is mysql database stored?

533


What is mysql database extension?

474


What is the command line end user interface - mysql?

525


How to Set a root password if there is on root password.

584


How to use regular expression in pattern match conditions?

519