Compare the values of column in SQL Server

Just select the needed columns:

SELECT A, B
FROM Table_1
WHERE B IN (2,3,4)

EDIT:
If you need them only if all params are present

    SELECT A, B
    FROM Table_1
    WHERE A IN (SELECT A FROM Table_1 WHERE B = 2) AND A IN (SELECT A FROM Table_1 WHERE B = 3) AND A IN (SELECT A FROM Table_1 WHERE B = 4)