SQL <> function help

former_member548403 — Tue, 13 Feb 2018 21:43:15 GMT

I'm trying to get <> function work, and it seems like I'm doing something wrong. I'm trying to not include values 411000 and 411005 by including them in a bracket with <> function. I'm told that the requirement is to use "OR" here. When I run the below code, the result includes both values. What am I doing wrong?

select u.IncidentNumber, u.PrimaryRoleOfUnit
from INC_UnitInformation u
where (u.PrimaryRoleOfUnit  <> 411000 or u.PrimaryRoleOfUnit <> 411005)

Re: SQL <> function help

former_member532835 — Tue, 13 Feb 2018 23:14:15 GMT

select u.IncidentNumber, u.PrimaryRoleOfUnit
from INC_UnitInformation u
where (u.PrimaryRoleOfUnit  <> 411000 and u.PrimaryRoleOfUnit <> 411005)

I believe the OR is your problem, when it is either of these 2 values the other side of the OR is TRUE so the value gets returned. Try the AND like I posted above.

topic Re: SQL <> function help in Application Development and Automation Discussions

SQL <> function help

Re: SQL <> function help