Mail.ruПочтаМой МирОдноклассникиВКонтактеИгрыЗнакомстваНовостиКалендарьОблакоЗаметкиВсе проекты

Помогите решить задачу sql

Debil Ученик (184), на голосовании 11 месяцев назад
На складе (warehouse) №1 хранятся товары (name) с одинаковыми наименованиями, имеющие различную стоимость (price.) Данные хранятся в таблице goods. Необходимо получить список товаров без учета их стоимости и без повторений. Результат отсортировать по id.

Какой из перечисленных фрагментов кода позволит решить поставленную задачу?


Select name from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1
Select distinct name, price from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1 order by id
Select distinct name, price from goods where warehouse = 1
Голосование за лучший ответ
1Сник Мудрец (14829) 12 месяцев назад
4) Select distinct name from goods where warehouse = 1 order by id
5 Знаток (425) 10 месяцев назад
изи же:Select name from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1
Select distinct name, price from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1 order by id
Select distinct name, price from goods where warehouse = 1
Select name from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1
Select distinct name, price from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1 order by id
Select distinct name, price from goods where warehouse = 1
Select name from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1
Select distinct name, price from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1 order by id
Select distinct name, price from goods where warehouse = 1
Select name from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1
Select distinct name, price from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1 order by id
Select distinct name, price from goods where warehouse = 1
Select name from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1
Select distinct name, price from goods where warehouse = 1 order by id
Select distinct name from goods where warehouse = 1 order by id
Select distinct name, price from goods where warehouse = 1
Похожие вопросы