I have the following oracle SQL and its works and all but it's quite ugly with all of the
or
s. 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
Last activity: Feb 19, 2017, 05:46 PM