每天加载之后,我会检查表中是否有任何数据问题。这是使用select查询查找重复项来实现的。AS TABLENAME FROM (Select Count(1) AS DUPS from DW.PLAYER group by PLAYERID having count(1) > 1) A一个表的样本输出:我有一个select查询来查找40个表中的每个表的副本
您好,当我将一个表数据的计数插入到另一个表中时,我不知道如何做,因为我对SQL和c# .net.Below是新手,所以附上了我的代码。(title,repeat) select title, COUNT(*) as repeat from glassdoor GROUP BY title HAVING COUNT(*) > 1 unionselect title, COUNT(*) as repeat from mitula GROUP BY title HAVING COUNT(*) > 1 union