mysql查询重复数据的语句

select lender_id,sign_day from caiyun_v02_other.shop_user_sign_log group by lender_id,sign_day having count(*) > 1 ;//重复2个字段的数据

select lender_id,sign_day from caiyun_v02_other.shop_user_sign_log group by lender_id,sign_day having count(*) > 1 and lender_id=391446 limit 10;  //查询具体一个人重复的次数