Можно ли упростить приведенный запрос с UNION? Если да, то как?
SELECT id, prod_id, price FROM goods WHERE price <= 5 UNION SELECT id, prod_id, price FROM goods WHERE id IN (100,104)
SELECT id, prod_id, price FROM goods WHERE price <= 5 UNION SELECT id, prod_id, price FROM goods WHERE id IN (100,104)
Anonymous Quiz
SELECT id, prod_id, price FROM goods WHERE price = 5 AND id IN (100,104)
SELECT id, prod_id, price FROM goods WHERE price = 5 !AND id IN (100,104)
SELECT id, prod_id, price FROM goods WHERE price = 5 OR id IN (100,104)
Упростить нельзя
Нет верного варианта ответа
Посмотреть ответ
493 answered
tgoop.com/sqlquestions/1006
Create:
Last Update:
Last Update:
BY SQL задачи
Share with your friend now:
tgoop.com/sqlquestions/1006