sql 找出重複資料

同一table要找出num有重複的筆數可以下以下指令
select *
from user T1 where (select count(*) from user T2 where T1.num = T2.num) >1