sql语句怎么查重复数据 如何查找重复数据

SQL查询语句,怎样查询重复数据？Select id，count（1）count of repetitions from a group by id having co...