你可以试一试如下语句:将中间的字段,表换成你自己的
然后删除重复的记录。
SELECT [图号], [项目], [装置], [专业]
FROM 工程图
WHERE [图号] In (SELECT [图号] FROM [工程图] As Tmp GROUP BY [图号] HAVING Count(*)>1 )
ORDER BY [图号]
还不行的话,你在表中添加一个字段,
然后将字段信息放成记录号。
再查,删除记录号重复的就可以了
试过了:
Checking helhw1
The total number of data pages in this table is 2151.
Table has 59297 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.