1、查找单个字段
1 | select 字段名,count(*) from table group by 字段名 having count(*) > 1 |
2、查找组合字段：
1 | SELECT TEST_NAME1,TEST_NAME2,COUNT(*) FROM table GROUP BY TEST_NAME1,TEST_NAME2 HAVING COUNT(*) > 1 |
Oracle 查询表中字段里数据是否有重复
1、查找单个字段
1 | select 字段名,count(*) from table group by 字段名 having count(*) > 1 |
2、查找组合字段：
1 | SELECT TEST_NAME1,TEST_NAME2,COUNT(*) FROM table GROUP BY TEST_NAME1,TEST_NAME2 HAVING COUNT(*) > 1 |
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
