実行の順序忘れないようにメモ(・∀・)
上 → 先
下 → 後
| 〜句 | 内容 |
|---|---|
| from | テーブル指定 |
| join | テーブルの結合 |
| where | 条件指定 |
| group by | グループ化 |
| sum,avgなど | 関数 |
| having | 集計後の絞り込み |
| select, distinct | 検索 |
| order by | 並べ替え |
| limit | 取得件数の指定 |
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme