主题：删除重复记录

假设要删除表A第一列的重复记录，代码:

Dim cmd As New SQLCommand
cmd.CommandText = "Delete From {表A} where [_Identify] Not In (Select max([_Identify]) From {表A} Group by 第一列)"
cmd.ExecuteNonQuery()
DataTables ("表A").Load()