2022-01-29から1日間の記事一覧

SQL

ELECT 農家名, SUM(金額) FROM article7 WHERE 日時 BETWEEN '2022-01-11' AND '2022-01-25' GROUP BY 農家名, 組勘番号 ORDER BY 組勘番号; どうも ORDER BYを使うときに GROUP BYのところにも 入れなきゃだめみたいだ SELECT 農家名, SUM(金額) FROM artic…

SQL

ELECT 農家名, SUM(金額) FROM article7 WHERE 日時 BETWEEN '2022-01-11' AND '2022-01-25' GROUP BY 農家名, 組勘番号 ORDER BY 組勘番号; どうも ORDER BYを使うときに GROUP BYのところにも 入れなきゃだめみたいだ SELECT 農家名, SUM(金額) FROM artic…

SQL

ELECT 農家名, SUM(金額) FROM article7 WHERE 日時 BETWEEN '2022-01-11' AND '2022-01-25' GROUP BY 農家名, 組勘番号 ORDER BY 組勘番号; どうも ORDER BYを使うときに GROUP BYのところにも 入れなきゃだめみたいだ SELECT 農家名, SUM(金額) FROM artic…

SQL

ELECT 農家名, SUM(金額) FROM article7 WHERE 日時 BETWEEN '2022-01-11' AND '2022-01-25' GROUP BY 農家名, 組勘番号 ORDER BY 組勘番号; どうも ORDER BYを使うときに GROUP BYのところにも 入れなきゃだめみたいだ SELECT 農家名, SUM(金額) FROM artic…