¿Cuantos registros retorna esta consulta?

DECLARE @EmployeeDetails TABLE (EmpNo Int ,
                     EmpName Varchar(10),
                     EmpPlace Varchar(100))
                    
Insert into @EmployeeDetails Values(1,'samith',NULL)
Insert into @EmployeeDetails Values(2,'sreepathi','Kannur')
Insert into @EmployeeDetails Values(3,'Jamsheer','Calicut')
Insert into @EmployeeDetails Values(4,'Naseer',NULL)
Insert into @EmployeeDetails Values(5,'Rejith','Palakkad')

SELECT *
FROM @EmployeeDetails
WHERE EmpPlace <> 'Kannur'

La respuesta mas abajo…

Respuesta: ¡2! El valor NULL tambien coincide con la condicion en caso de operadores NOT (<>,Not in ,Not like..)

Fuente: sqlservercentral.com