Tuesday, 13 August 2013

Priority of an OR statement SQL

Priority of an OR statement SQL

I have the following snippet code:
WHERE (Person.WorkGroupId = 2 or Person.RoleId = 2)
What I would like to happen is for this to return the first person with a
WorkGroupId of 2. But, if there is not a person with a WorkgroupId of 2,
then choose the first person with RoldId of 2.
Thanks

No comments:

Post a Comment