mysql: select maximum year value from my table?

Question

Hi all, very good morning to everybody.

ID           Value       Year
10           Singapore   2010
10           Malaysia    2009
10           India       2008

This is my table. Now I want to retrieve maximum year record only.

Example:

ID             value       year
10             Singapore   2010

how can i write query in MySql?

please advice me.

Answer 1

select * from tbl order by year desc limit 1

assuming year is unique