Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dollarbillg
Yak Posting Veteran
52 Posts |
 Posted - 2001-10-15 : 10:01:35
|
| I need to remove duplicate records from a table below is my select statement that gives me the dups. How can I use this statement or modify it so that the query will remove all dups. form the table?SELECT DISTINCTROW First([68sdi COPY].DWGNO) AS [DWGNO Field], First([68sdi COPY].ASBUILT) AS [ASBUILT Field], Count([68sdi COPY].DWGNO) AS NumberOfDupsFROM [68sdi COPY]GROUP BY [68sdi COPY].DWGNO, [68sdi COPY].ASBUILTHAVING (((Count([68sdi COPY].DWGNO))>1) AND ((Count([68sdi COPY].ASBUILT))>1));Thanks in advance for any and all help!!Bill |
|
|
|
|
|
Deleting Duplicate Records in a table