MySQL SELECT 語法完整參考：從基礎到進階選項一覽

MySQL SELECT 語句完整語法與選項速查表

SELECT
    [STRAIGHT_JOIN]
    [SQL_SMALL_RESULT]
    [SQL_BIG_RESULT]
    [HIGH_PRIORITY]
    [DISTINCT | DISTINCTROW | ALL]
    select_expr [, select_expr ...]
    [INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
    [FROM table_references
        [WHERE where_condition]
        [GROUP BY {col_name | expr | position} [ASC | DESC], ...]
        [HAVING where_condition]
        [ORDER BY {col_name | expr | position} [ASC | DESC], ...]
        [LIMIT {[offset,] row_count | row_count OFFSET offset}]
        [PROCEDURE procedure_name(argument_list)]
    ]
    [FOR UPDATE | LOCK IN SHARE MODE]

關鍵選項說明

常用子句執行順序

1. FROM / JOIN — 確定資料來源
2. WHERE — 列級過濾
3. GROUP BY — 分組
4. HAVING — 組級過濾
5. SELECT — 投影欄位
6. DISTINCT — 去重
7. ORDER BY — 排序
8. LIMIT — 限制輸出行數

提示： 理解執行順序有助於撰寫正確邏輯（如 WHERE 不能用別名，HAVING 可用聚合函數）。