用SQL查询重复记录的参考资料

原SQL：
SELECT T.WID,T.AID,T.PID,T.GID,T.QUAL,WAREHOUSE.WNAME,AREA.ANAME,
BASEGOODS.GNAME,DIC.MEAN,T.RECEMAN,RECEIVER.RELA,T.WANUM,
T.QTY FROM (SELECT INOUT_POSITION.WID,INOUT_POSITION.AID,
INOUT_POSITION.PID, INOUT_POSITION.GID,INOUT_POSITION.QUAL,
WARRANT.RECEMAN,WARRANT.WANUM, SUM(INOUT_POSITION.SCOUNT) AS QTY
FROM INOUT_POSITION,INOUT,WARRANT
WHERE
INOUT_POSITION.INID=INOUT.I

-------------------------------------------------------------
select * from 表 group by 字段 having count(字段)>1
-------------------------------------------------------------
select *
from Information
where Name in (
select Name from Information group by name having count(*)>1)
-------------------------------------------------------------
http://www.itpub.net/273808.html

http://topic.csdn.net/t/20050228/09/3810928.html

http://book.77169.org/ask35/how153522.htm

http://www.itpub.net/162263.html