Compare 4 or more columns values
I'm not familiar with SQL Server's brand of 
SQL, but it must be something like:

SELECT ID FROM My_Table 
WHERE 
(A0 = A1) AND
(A1 = A2) AND
(A2 = A3) AND
(A3 = A4);


Check out this dbfiddle.uk which shows all the answers in the answer thread.