原文链接 http://t.zoukankan.com/c-Ajing-p-13448349.html在实际开发中，可能会遇到数据库多条数据重复了，此时我们需要删除重复数据，只保留一条有效数据，用SQL语句怎么实现呢，下面我们模拟一下：1.准备重复数据：2.
This macro will delete rows that appear twice in a list or worksheet. If two cells are identical， this macro will delete every row with an identical cell which is underneath the first occurrence. The first instance will still remain， but all identical cells in the rows underneath the original cell will be deleted. In order to run the macro， you need to select the entire column where you want to search for duplicates and then run the macro.我20多年的VBA实践经验，全部浓缩在下面的各个教程中:
