求一个SQL语句？

[yzflying]

表Product中有一个字段:产品类别（ProductType）,共5种类别的产品，但每种类别的产品有几百种，我现在想选出每种类别的最新的一条纪录。

ID ProductType Name
1 a 11
2 a 22
3 a 55
4 b 66
5 b 22
6 c cc
7 c fasdf
8 a adf
9 d fasdf
......
我现在想得到，关于a、c、d、e、f的每个类别的最新的产品（ID递增）

[txlicenhe]

Select a.* from 表 a
join
(Select ProductType,max(id) as id from 表 group by ProductType) b
on a.id = b.id

[aierong]

ID ProductType Name
1 a 11
2 a 22
3 a 55
4 b 66
5 b 22
6 c cc
7 c fasdf
8 a adf
9 d fasdf

select *
from tablename
where id in(select max(id) from tablename group by producttype)

[yujohny]

select * from 表 a where id=(select max(ID) from 表 where ProductType=a.ProductType)

[aierong]

ID ProductType Name
1 a 11
2 a 22
3 a 55
4 b 66
5 b 22
6 c cc
7 c fasdf
8 a adf
9 d fasdf

select *
from tablename as a
where id=(select max(id) from tablename as b where b.ProductType=a.ProductType)

[aierong]

select *
from aii as a
where id=(select max(id) from aii as b where b.ProductType=a.ProductType)

select r.*
from aii as r join (select ProductType,max(id) as maxid from aii group by ProductType) as l
on r.id=l.maxid

[zjcxc]

select * from Product a where id=(select max(id) from Product where ProductType =a.ProductType )

[9809375117]

select product.*
from product,
(select max(id) as id from product gourp by productType)b
where product.id=b.id