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

How do I create a mysql username and password?

943

What is default schema in mysql?

972

How do you rename a table in mysql?

1102

What do you need to connect php to mysql?

1036

Why does mysql have so many connections?

942

What is the datatype of image?

1003

What is action query?

946

How do I find users in mysql?

1174

Is mariadb faster than mysql?

1009

What language does mysql use?

952

How to find second highest salary from a table?

1060

How do I kill a mysql query?

954

Where is mysql installed on linux?

968

How to decrement dates by 1 in mysql?

1058

Can we join 3 tables in mysql?

1026