mysql GROUP BY删除查询重复记录

SELECT *  
FROM (  
SELECT *  
FROM dede_archives  
ORDER BY id DESC  
)arc, dede_soft b  
WHERE arc.id = b.aid  
GROUP BY `shorttitle`  
ORDER BY `id` DESC  
LIMIT 0 , 30  

delete from people where peopleid in (select peopleid from people group by peopleid having count

(peopleid) > 1) and rowid not in (select min(rowid) from people group by peopleid having count

(peopleid )>1)

select *, count(distinct name) from table group by name

结果:

id name count(distinct name)
1 a 1
2 b 1
3 c 1