In my result set I have One column with values 1 and 2. I want to use the row with 2 only when value 1 does not exist.
For Example Result is
ACCT VALUE
112 1
112 2
222 1
312 1
312 2
422 2
Notice how ACCT 222 Value is 1 but only has 1 return result, and ACCT 422 Value is 2 but only has 1 return result.
New contributor
Kiel Satake is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.