I generate a small table with a SELECT INTO from a larger table. One of the fields in the new table is 'Org'. I have to treat Org = ABC as a special case. So IF the Org in the first row is ABC, DELETE all other rows.
If the Org in the first row is NOT ABC, keep all rows.
How would I construct this query?