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

Does mysql use tcp or udp?

903

How do I run mysql?

982

Is mysql free for enterprise?

875

Can you tell how many values can set the function of mysql to consider?

960

Which is faster mysql or mongodb?

894

How do I delete a table in mysql workbench?

1018

What is the limit of mysql database?

942

What are programming functions?

931

Write command to import an mysql file?

1016

Why do we use the mysql database server?

1024

How is mysql database stored?

1051

How does mysql store binary data?

929

What is memory table?

888

What is difference between mysql and mariadb?

1083

How to make a column bigger and delete unique from table.

938