Which one of the following SQL statements produces the same result as select grocery_aisle, grocery_shelf, grocery_ bin, grocery_fruits from grocery where grocery_fruits IN ('apple','orange','pear') ?...



Which one of the following SQL statements produces the same result as
select grocery_aisle, grocery_shelf, grocery_ bin, grocery_fruits
from grocery
where grocery_fruits IN ('apple','orange','pear') ?



Question 19 options:






































1)


select grocery_aisle, grocery_shelf, grocery_ bin, grocery_fruits
from grocery
where grocery_fruits = 'apple' AND grocery_fruits ='orange' AND grocery_fruits ='pear';




















2)


select grocery_aisle, grocery_shelf, grocery_ bin, grocery_fruits
from grocery
where grocery_fruits LIKE ('apple','orange','pear');




















3)


select grocery_aisle, grocery_shelf, grocery_ bin, grocery_fruits
from grocery
where grocery_fruits = 'apple' OR grocery_fruits ='orange' OR grocery_fruits ='pear';




















4)


select grocery_aisle, grocery_shelf, grocery_ bin, grocery_fruits
from grocery
where grocery_fruits = ('apple' OR 'orange' OR 'pear');







Jun 06, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?