sql中如何查询一个表中重复的数据，并且重复了几次？

sql中如何查询一个表中重复的数据，并且重复了几次？

select col001,sum(1) as ufo from lhsjb group by col001 having sum(1) > 1

用VLOOKUP 或者数据透视表

select col001,count(0) as counter from lhsjb group by col001 having counter >1

select col001,count(col001) from lhsjb where coloo1>1 group by col001

select col001，count(col001) from lhsjb where count(col001) > 1 group by col001

select col001 as ufo,sum(1) from lhsjb group by col001