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 is difference between mysql and mysqli?

921

How do you stop an access query?

911

What is information_schema in mysql?

992

Does mysql case matter?

909

How to Change a users password from unix shell.

1122

change column name and make a unique column so we get no dupes.

984

How do I copy an entire mysql database?

898

What is int mysql?

949

Why use stored procedures in mysql?

986

What is normalization and list the different types of normalization?

952

What are Heap tables?

1564

How big is a blob mysql?

892

What is difference between inner vs self vs cross?

964

What is mysql and mysqli?

929

Can you tell few best practices to be followed for optimization in sql?

900