请教一个sql语句!谢谢

[maotin]

我有一个结果集:
----------------------------------------------------
ID CompanyID ProductDetailID Count
10 50 682 A
11 50 682 B
14 60 689 C
15 60 689 D
18 70 697 E
19 70 697 F
20 70 697 G
-----------------------------------------------------

我想取出CompanyID和ProductDetailID一样得,但是ID是最小得那一条记录
请问怎么写sql?
谢谢!

[maotin]

这是我想要得结果:
----------------------------------------------------
ID CompanyID ProductDetailID Count
10 50 682 A
14 60 689 C
18 70 697 E
-----------------------------------------------------

[lsxaa]

select a.*
from 表 a,(select min(ID) as id,CompanyID,ProductDetailID
from 表
group by CompanyID,ProductDetailID ) b
where a.id=b.id

[pbsql]

select * from t,
(select id=min(id),CompanyID,ProductDetailID from t group by ompanyID,ProductDetailID) a
where t.id=a.id and t.CompanyID=a.CompanyID and t.ProductDetailID=a.ProductDetailID

[clx333]

select * from tb a where not exists (select * from tb where companyid=a.companyid and productdetailid=a.productdetailid and id>a.id)

[子陌红尘]

select
a.*
from
tabname a
inner join
(select CompanyID,ProductDetailID ,min(ID) as ID
from tabname
group by CompanyID,ProductDetailID ) b
on
a.CompanyID = b.CompanyID and a.ProductDetailID = b.ProductDetailID and a.ID = b.ID

[didoleo]

select * from 表 a
where not exists (select * from 表 where companyid=a.companyid and productdetailid=a.productdetailid and id<a.id)

[tengjian1981]

select a.*,b.Count
from
(select min(ID) as id,CompanyID,ProductDetailID
from Table
group by CompanyID,ProductDetailID ) a
left join Table b on a.ID=b.ID

[vinsonshen]

楼主帮试下这个：
select * from 表名 as a where not exists (select * from 表名 where CompanyID=a.CompanyID and ProductDetailID=a.ProductDetailID and [ID]<a.[ID])