文件中存在相同数据

来源:互联网 发布:物流网络 编辑:程序博客网 时间:2024/05/20 03:42
 EXISTS (SELECT 1
              FROM (SELECT CUSTOMS_CODE,comp_no
                      FROM INFO_CUSTOMS_TMP
                     GROUP BY CUSTOMS_CODE,comp_no
                    HAVING COUNT(*) > 1)
原创粉丝点击