oracle 查询表中字段里数据是否有重复
?查单个字段：
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 TEST_NAME1,TEST_NAME2 HAVING COUNT(*) > 1
?
?
?
?
发布时间： 2013-10-19 20:58:22 作者： rapoo
oracle 查询表中字段里数据是否有重复
?查单个字段：
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 TEST_NAME1,TEST_NAME2 HAVING COUNT(*) > 1
?
?
?
?