🖥
SQL | GROUP BY and WHERE order
Write the WHERE first.
↓ Move.
SELECT id FROM user WHERE name = 'John' GROUP BY id
↓ It does not move.
SELECT id FROM user GROUP BY id WHERE name = 'John'
Original by
About
チャットメンバー募集
何か質問、悩み事、相談などあればLINEオープンチャットもご利用ください。
公開日時
2019-04-16
Discussion