苏斌's blog

下面的语句可以达到要求:              

                    delete 表 where id not in(
                                SELECT MAX(id) AS id FROM 表 GROUP BY rows) --- 删除重复行

                   select * from 表 where id in(
                                 SELECT MAX(id) AS id FROM 表 GROUP BY rows) --重复行只查询一条

实际使用时：

--重复行只查询一条
SELECT *
FROM [23]
WHERE (ID IN
          (SELECT MAX(id) AS id
         FROM [23]
         GROUP BY name))
order by id