如何统计表里面有重复 数据

方案一：如果要找的是表里面某几列重复，而不是所有列

SELECT column1, column2, ..., COUNT(*)
FROM your_table_name
GROUP BY column1, column2, ...
HAVING COUNT(*) > 1;

参考示例

select VC_CONFIRMNO, VC_TACODE, VC_CONFIRMDATE from tdividenddetail_liq group by VC_CONFIRMNO, VC_TACODE, VC_CONFIRMDATE
having count(*)>1