类似Excel中Vlookup效果,提取重复数据中第一次出现的值.思路,为数据添加一列自增字段,通过判断自增字段数值大小来提取不重复数据。

sql语句:

Select a.ID, a.组织, a.装配件 FROM BOM AS a INNER JOIN (Select Min(BOM.ID) AS RID, BOM.装配件
FROM BOM GROUP BY BOM.装配件 ORDER BY Min(BOM.ID))  AS b ON (a.ID = b.RID) AND (a.装配件 = b.装配件) ORDER BY a.ID

附   件:

点击下载此附件