CODEWITHSUNDEEP
sqlsql-servert-sqlsql-server-2012
user3123888
user3123888

Reputation: 3

SQL compare two columns for same value

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.

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.

Upvotes: 0

Views: 189

Answers (2)

Aram
Aram

Reputation: 5705

You can go like:

SELECT CASE WHEN Scan1 = Scan2 THEN 1 
       ELSE 0 END AS ColumnAlias
FROM YourTable

Upvotes: 2

a1ex07
a1ex07

Reputation: 37354

Something like SELECT .... , CASE WHEN scan1 = scan2 THEN 1 ELSE 0 END AS is_equal FROM table1 should do the job.

Upvotes: 4

Related Questions