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

Is mongodb faster than mysql?

953

How important is to list the column names when doing an insert?

1042

How do I kill a mysql query?

903

How to get a list of columns in an existing table?

883

How to calculate the difference between two dates?

1062

Is mysql free for commercial use?

924

Why use mysql procedures?

986

What causes mysql too many connections?

962

What is difference between mysqli and pdo?

934

How to enable or disable a row of a table using MySQL in struts?

4099

What are mysql queries?

926

Is primary key auto increment?

946

How to enter microseconds in sql statements?

983

How do I start mysql?

891

Is foreign key indexed mysql?

894