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