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 does blob mean in mysql?

910

How many TRIGGERS are allowed in MySql table?

1021

What are the difference between and myisam and innodb?

960

Explain the difference between primary key and candidate key in mysql?

907

Where is the mysql data directory?

888

What is localhost in mysql?

965

How do I find mysql location?

916

How do I delete a table in mysql workbench?

976

How to run a sql statement?

966

What is the difference between timestamp and datetime in mysql?

978

How does mysql store dates?

880

How do I know if mysql is running on windows?

980

Why mysql is so popular?

906

Difference between CHAR and VARCHAR?

1023

What is mysql shell?

910