select * from table_name,(select 货品, max( 年份 ) as 年份 from table_name group by 货品) T where table_name.货品=T.货品 and table_name.年份=T.年份
select 表.* from 表 ,(select max(年份) a,货品 from 表 group by 货品) aa where 表.货品 = aa.货品 and 表.年份 = aa.a
select * from tbl where 年份 in ( select max(年份) from tbl)
选出这种表的思想是,先把条件选出来,然后用整表与条件表内联的方法选出记录。如下:select 所需的所有字段名 from 表 as T1 Inner Join (select max (年份) as X,货品 as Y from 表 group by 货品) as T2 ON t1.货品=t2.Y AND t1.年份=t2.X
from 表 as T1
Inner Join
(select max (年份) as X,货品 as Y from 表 group by 货品) as T2
ON
t1.货品=t2.Y AND
t1.年份=t2.X