摘要： 查单个字段：SELECT TEST_NAME,COUNT(*) FROM T_TEST GROUP BY TEST_NAME HAVING COUNT(*) > 1; 查组合字段：SELECT TEST_NAME1,TEST_NAME2,COUNT(*) FROM T_TEST GROUP BY T 阅读全文