查出数据库中重复记录的方法 -[默认分类]
select * from 表 group by 字段 having count(字段)>1
-------------------------------------------------------------
select *
from Information
where Name in (
select Name from Information group by name having count(*)>1)
xiaosheng 于 2007-03-27 15:53:15 回复主题:re:查出数据库中重复记录的方法
内容: SELECT ac.uid, uc.OrderExpert, count( * ) ccount
FROM accountexpencedetail ac
LEFT JOIN useraccount uc ON uc.uid = ac.uid
WHERE ac.recash !=0
GROUP BY ac.uid
HAVING count( * ) >1
ORDER BY ccount DESC