Using a single query not sub-query SELECT * FROM `employee` ORDER BY sal

Print 3 highest salary

Question Posted / lokesh das

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

Please Help Members By Posting Answers For Below Questions

How to decrement dates by 1 in mysql?

989

What are mysql functions?

934

Can python connect to mysql?

990

How to create a new table in mysql?

1024

How to use triggers to track changes in mysql?

856

How do I show columns in mysql?

915

How is data stored in mysql?

911

How to filter data from a mysql database table with php?

880

How will you export tables as an xml file in mysql?

874

What is the use of count function in mysql?

1014

What is difference between microsoft sql and mysql?

967

How do you stop an access query?

896

Explain the different types of mysql joins.

906

How do I change a procedure in mysql?

985

Is mysql free software?

948