Use of 1=2 in a SQL query

Question

Someone please explain the meaning of '1=2' in the below SQL query.

SELECT E.EmpID,
       E.EmpName,
       Country = CASE
                   WHEN T.Active = 'N'
                        AND 1 = 2 THEN 'Not Working Anymore'
                   ELSE C.Country_Name
                 END,
       T.Contract_No
FROM   Employees E (nolock)
       INNER JOIN Contract T
         ON T.Contract_No = E.Contract_No
       LEFT JOIN Country C (nolock)
         ON E.Country_ID = C.Country_ID 

thanks

EDIT:- Corrected the slight mistake existed in the example SQL query given by me. @ ALL :- The query mentioned here is an example version of a big working query on which I have to reoslve something. I have created a sample scenario of SQL query for the sake of simplicity of question.

Answer 1

There is a good use for this 1=2 part of the WHERE clause if you are creating a table from another, but you don't want to copy any rows. For example:

CREATE TABLE ABC_TEMP AS
    SELECT * FROM ABC WHERE 1=2;