SQL 比较两列的相同值 [英] SQL compare two columns for same value

问题描述

对于 SQL Server 2012，我有两列要进行比较.两者都在同一张桌子上，所以不需要连接.

With SQL Server 2012, I have two columns that I would like to compare. Both are on the same table, so no joins are needed.

基本上我需要比较两列，例如 scan1 和 scan2，如果它们的值匹配，那么我需要一个 1，否则<代码>0.匹配结果将输出到AS Results.

Basically I need to compare two columns, for example scan1 and scan2 and if their value's match, then I need a 1, else 0. The results of the match would output to AS Results.

推荐答案

类似 SELECT .... , CASE WHEN scan1 = scan2 THEN 1 ELSE 0 END AS is_equal FROM table1 应该可以.

这篇关于SQL 比较两列的相同值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！