-
sql表插入语句时ab表同时出现的数据舍弃,求具体语句
SELECT *FROM (SELECT T.ID, T.NAME, COUNT(1) OVER(PARTITION BY T.ID, T.NAME) CFCSFROM (SELECT * FROM a UNION ALL SELECT
SELECT *FROM (SELECT T.ID, T.NAME, COUNT(1) OVER(PARTITION BY T.ID, T.NAME) CFCSFROM (SELECT * FROM a UNION ALL SELECT
