Sample Header Ad - 728x90

Avoiding multiple `or` expressions

13 votes
3 answers
4158 views
I have the following oracle SQL and its works and all but it's quite ugly with all of the ors. Is there a more concise way of doing this? SELECT * FROM foobar WHERE (SUBJECT ='STAT' and TERM ='111') or (SUBJECT ='STAT' and TERM ='222') or (SUBJECT ='ENGLISH' and TERM ='555') or (SUBJECT ='COMM' and TERM ='444') or (SUBJECT ='COMM' and TERM ='333') or (SUBJECT ='STAT' and TERM ='666') ...
Asked by Kyle Decot (359 rep)
Dec 31, 2014, 06:41 PM
Last activity: Feb 19, 2017, 05:46 PM