SQL looks for repeated records

SELECT UID, DDFROM (SELECT UID, Count (Uid) AS DD from dbo.cn_infomation group by uid) derivedtblwhere (DD> 1)

Select * from memberswhere (SELECT MEMBER_ID, COUNT (MEMBER_ID) AS DD from DBo.members Group by Member_ID) DerivedTBL Where (DD> 1))))))))))