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 session variable in mysql?

911

How to returns the columns and column information pertaining to the designated table.

975

What is the difference between truncate and delete in mysql?

1083

What are the different column comparison operators in mysql?

891

What is truncate command?

877

How to control the max size of a heap table?

932

How can I change database in mysql?

840

What is an index? How can an index be declared in mysql?

835

What is the use of mysqli_num_rows?

870

What is a blob datatype?

816

How do I edit a table in mysql workbench?

795

What is latest version of mysql?

949

Why mysql is open source?

864

How do I transfer data from one database to another in mysql?

858

Is mysql easy to learn?

881