[solved] – Question 76383

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’)

Expert Answer

---