Condition to file some string from query
Posted on 2012-04-02
I'm using SQL Developer to write query. In one of my query I get pretty much the result I want but notice that there are some extra rows that I would like to exclude, i.e.,
For column 'Program_ID', I only want 'A0' amongst A0, A1, ... A9. I also want to have B, C, D and other values
Can you suggest what should I add in the WHERE statement to accomplish this task ?