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

Will mysql remain free?

965

What, if a table has one column defined as TIMESTAMP?

1018

How you will show all data from a table.

999

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

932

What is the difference between char and varchar?

1196

Why is mysql used?

944

How do I add a column to a table in mysql?

918

How to decrement dates by 1 in mysql?

1013

Does uninstalling mysql delete database?

1028

How is data stored in mysql?

939

What is the use of mysql_fetch_array () function in php?

942

How do I install mysql on windows 7?

999

What is a result set object?

961

What language is mysql written in?

995

How to analyze tables with 'mysqlcheck'?

1210