How to find out the second largest element from mysql table

Answer Posted / md aftab alam

select distinct final_id from care_billing_final order by final_id
desc limit 1,1;

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we delete a row in a table?

622


Can you shard mysql?

578


What are the advantages/disadvantages of mysql and php?

569


What is longblob?

617


What is mysql port?

639






Which storage engine is best in mysql?

568


How do I delete a table in mysql workbench?

613


How can you increase the performance of mysql select query?

558


What is mysql and why it is used?

643


How do I create a mysql database?

577


How do I know if mysql is running on windows?

560


Can you tell which of the following where clauses is faster?

524


What is a mysql view?

554


How to use count function in mysql?

553


How do I free up space in mysql?

556