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

How do I delete a table in mysql workbench?

1085

What is a result set object?

1013

What is the return type of mysqli_query?

922

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

972

What is orm in mysql?

954

Explain the storage engines in mysql?

1056

What is 'mysqlshow'?

1119

What is difference between function and procedure in mysql?

1011

What is difference between mysqli and pdo?

1005

How many columns can you create for an index?

1000

What is the difference between BLOB AND TEXT?

1224

What is the latest mysql?

1000

What does it mean to be case sensitive?

1062

How do I setup a mysql database?

1039

What is a query in mysql?

1067