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

Write a program using the select statement, while loop.

917

In how many ways we can retrieve data in the result set of mysql using php?

1133

How do I set user privileges in mysql?

893

How to determine the location of the data directory?

968

How do I stop a query in mysql workbench?

950

How to add a new column to an existing table in mysql?

996

What is a procedure example?

931

What is dblink?

898

What is clob datatype?

894

What is database migration in mysql?

1030

What is memory table?

911

What is blob and text in mysql?

1175

What are date and time intervals?

996

How MySQL Optimizes DISTINCT?

1119

What is key in mysql?

899