常用sql语句

查询重复记录sql语句

select code,count(*) as count from lmy_coupon group by code having count>1