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 are the technical specifications of mysql?

1109

What is a delimiter in mysql?

976

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

868

What is the latest version of php and mysql?

1161

How to do login in mysql with unix shell.

1055

How do I change the max connections in mysql?

855

What causes mysql too many connections?

903

How do I change a procedure in mysql?

956

What are the differences between char and nchar?

1039

How can you validate emails using a single query?

854

Can varchar be primary key?

892

What is a csv table?

964

Can you shard mysql?

895

How to delete the repeated records from a table?

932

What is heap table?

987