How to find out the second largest element from mysql table

Answer Posted / laxmanit08

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

Is This Answer Correct ?    49 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is constraints? Also explain the different types of constraints?

611


Is mysql easy to learn?

561


Is mysql frontend or backend?

546


What are the differences between a primary key and foreign key?

653


What data structure does mysql use?

648






How do I drop a database in mysql?

677


How do I stop a mysql command?

558


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2039


What is the difference between now() and current_date()?

581


What is myisam?

583


How does mysql store binary data?

583


What is an example of a delimiter?

588


What is the purpose of using timestamp data type?

579


What is a procedure example?

571


What, if a table has one column defined as TIMESTAMP?

638