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
How to execute mysql query in php?
What is a trigger in mysql?
How do I edit a database in mysql workbench?
What is bdb (berkeleydb)?
What is sql in mysql?
What is the difference between timestamp and datetime in mysql?
What is difference between mysql and mysql workbench?
Where is mysql used?
What is a crosstab query?
What is slow query log in mysql?
How do I create a schema in mysql?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
What is the difference between BLOB AND TEXT?
What are the applications required to support mysql?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products