Answer to Question #76383 in Databases | SQL | Oracle | MS Access for J

Question

Select the statement that is equivalent to the one below. Equivalent means that it would return the same records.

SELECT *

FROM ARRIVAL

WHERE ORIGIN = 'DUS'

OR ORIGIN = 'JFK'

OR ORIGIN = 'DFW'




SELECT *
FROM ARRIVAL
WHERE ORIGIN IN ('DUS', 'JFK', 'DFW')

SELECT *
FROM ARRIVAL
WHERE ORIGIN OR ('DUS', 'JFK', 'DFW')

SELECT *
FROM ARRIVAL
WHERE ORIGIN = ('DUS', 'JFK', 'DFW')

SELECT *
FROM ARRIVAL
WHERE ORIGIN AND ('DUS', 'JFK', 'DFW')

Answer 1

SELECT *
FROM ARRIVAL
WHERE ORIGIN IN ('DUS', 'JFK', 'DFW')