查单个字段:SELECTTEST_NAME,COUNT(*)FROMT_TESTGROUPBYTEST_NAMEHAVINGCOUNT(*) > 1
查组合字段:SELECTTEST_NAME1,TEST_NAME2,COUNT(*)FROMT_TESTGROUPBYTEST_NAME1,TEST_NAME2HAVINGCOUNT(*) > 1
查单个字段:SELECTTEST_NAME,COUNT(*)FROMT_TESTGROUPBYTEST_NAMEHAVINGCOUNT(*) > 1
查组合字段:SELECTTEST_NAME1,TEST_NAME2,COUNT(*)FROMT_TESTGROUPBYTEST_NAME1,TEST_NAME2HAVINGCOUNT(*) > 1