select final_id from care_billing_final order by final

How to find out the second largest element from mysql table

Question Posted / laxmanit08

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

Please Help Members By Posting Answers For Below Questions

What are the mysql database files stored in system ?

1017

How to display odd rows in student table in mysql?

952

What mysql means?

905

What is mysql common?

869

How do I update a variable in mysql?

896

How can you increase the performance of mysql select query?

888

How to calculate the difference between two dates?

1008

What is dump in mysql?

844

What storage engines are used in MySQL?

1011

How can you see all indexes defined for a table?

1083

How does mysql store data?

897

How do I copy a table in mysql?

906

What is mysql connector used for?

901

How do I create a schema in mysql?

845

What is the difference between unix timestamp and mysql timestamp?

1018