SQLinfo.ru - Все о MySQL

Форум пользователей MySQL

Задавайте вопросы, мы ответим

Вы не зашли.

#1 09.05.2019 14:47:49

zh12345
Участник
Зарегистрирован: 09.05.2019
Сообщений: 1

Помогите

Please return one row per vendor, which represents the vendor's oldest invoice (the one with the earliest date).
## Each row returned should include the following columns:
##
##  - "vendor_name" table t1
##  - "invoice_number" table t2
##  - "invoice_date" table t2
##  - "invoice_total" table t2

t1.vendor_id = t2.vendor_id
##
## Please sort the result set by "vendor_name" in ascending order.

СП

Неактивен

 

Board footer

Работает на PunBB
© Copyright 2002–2008 Rickard Andersson