select distinct final_id from care_billing_final order by final

How to find out the second largest element from mysql table

Question Posted / md aftab alam

Answer Posted / md aftab alam

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is mysql uuid?

916

How many concurrent queries can mysql handle?

878

Is there a free version of mysql?

924

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1049

How to present a past time in hours, minutes and seconds?

1030

What is difference between mysql_connect and mysql_pconnect?

1014

How do I disconnect mysql workbench?

1040

Why use mysql procedures?

965

What is blob and text in mysql?

1159

Is mysql a backend?

915

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

1076

Can we join 3 tables in mysql?

931

Write a program using the select statement, while loop.

891

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

920

Why do we use preparedstatement?

896