SqlServer 查找重复的数据（区分大小写）

最新推荐文章于 2022-07-21 09:37:21 发布

gzj316

最新推荐文章于 2022-07-21 09:37:21 发布

阅读量390

点赞数

文章标签：数据库

日文系统中 sqlserver中查找重复的数据（区分大小写）

写道

SELECT * FROM TABLE_NAME
WHERE (IKEYWORD COLLATE Japanese_CS_AS_KS_WS IN
(SELECT KEYWORD COLLATE Japanese_CS_AS_KS_WS AS Expr1
FROM TABLE_NAMEAS TABLE_NAME_1
GROUP BY KEYWORD COLLATE Japanese_CS_AS_KS_WS
HAVING (COUNT(*) > 1)))

中文系统中 sqlserver中查找重复的数据（区分大小写）

SELECT * FROM TABLE_NAME 
WHERE (IKEYWORD COLLATE Chinese_CS_AS_KS_WS IN 
(SELECT KEYWORD COLLATE Chinese_CS_AS_KS_WS AS Expr1 
FROM TABLE_NAMEAS TABLE_NAME_1 
GROUP BY KEYWORD COLLATE Chinese_CS_AS_KS_WS 
HAVING (COUNT(*) > 1)))