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
What is the usage of "i-am-a-dummy" flag in mysql?
What is pdo connection?
Is mysql a free database?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
What is processlist in mysql?
How do I start and stop mysql on windows?
How to delete a column and add a new column to database
What is mysql port?
can you tell the order of sql select statement? : Mysql dba
I want to start and stop mysql on windows? How do I do that?
Why do we use views instead of tables?
Is mysql a nosql database?
How can you change the password of a mysql user?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
What is delimiter in mysql trigger?