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

Why do we use the mysql database server?

1103

How do stored procedures work?

1115

What is query log in mysql?

1037

Is mysql a free database?

981

How to create a table?

1049

Where is mysql data stored?

934

How to use like conditions?

1038

change column name and make a unique column so we get no dupes.

1018

How to extract a unit value from a date and time?

997

Which datatype is used for email in mysql?

1003

how you will Create a database on the mysql server with unix shell.

1099

What are the different types of triggers in mysql?

1014

What language does mysql use?

951

What are string data types?

1069

What is database url for mysql?

1021