您可以使用SELECT DISTINCT
,或者这里是使用带有窗口函数的 CTE 的选项:
;WITH CTE AS (
SELECT [SCORECARD_NAME], [SCORE_NAME], [TOTAL_ROWS], [VALID_PERCENTAGE],[INVALID_ROWS],
ROW_NUMBER() OVER (PARTITION BY [SCORECARD_NAME]
ORDER BY [SCORECARD_NAME]) AS DuplicateCount
FROM Table_Name
)
SELECT * FROM CTE WHERE DuplicateCount = 1;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句