Compare field sql server

SELECT 
  CASE WHEN COLUMN1 = COLUMN2 
    THEN '1' 
    ELSE '0' 
  END 
  AS MyDesiredResult
FROM Table1
INNER JOIN Table2 ON Table1.PrimaryKey = Table2.ForeignKey

Similar codes

5 votes96 views1 answer
Postgres upsert
SQL
0 vote183 views1 answer
Mysql could not fetch tables
SQL
1 vote142 views1 answer
Postgres concat_ws
SQL
2 votes151 views4 answers
Sql query interview questions
SQL
37 votes144 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote151 views1 answer
Mssql dockere
SQL
0 vote186 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote140 views1 answer
Mysql add to number
SQL
0 vote132 views1 answer
Sql server select furst day of current year
SQL
0 vote160 views1 answer
MySQL - How to find word with the most similar beginning
SQL