SELECT
    [ALL | DISTINCT | DISTINCTROW ]
      [HIGH_PRIORITY]
      [STRAIGHT_JOIN]
      [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
      [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
    select_expr, ...
    [INTO OUTFILE 'file_name' export_options
      | INTO DUMPFILE 'file_name']
    [FROM table_references
    [WHERE where_definition]
    [GROUP BY {col_name | expr | position}
      [ASC | DESC], ... [WITH ROLLUP]]
    [HAVING where_definition]
    [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]]

SELECT columna columnb FROM mytable;

SELECT college, region, seed FROM tournament  ORDER BY region, seed;
SELECT college, region AS r, seed AS s FROM tournament ORDER BY r, s;
SELECT college, region, seed FROM tournament  ORDER BY 2, 3;

--要以相反的順序進行分類，應把DESC（降序）關鍵字添加到ORDER BY子句中的列名稱中。默認值為升序；該值可以使用ASC關鍵詞明確地指定。
SELECT a, COUNT(b) FROM test_table ORDER BY a DESC；

SELECT a, COUNT(b) FROM test_table GROUP BY a DESC；
SELECT COUNT(col1) AS col2 FROM t GROUP BY col2 HAVING col2 = 2;

-- HAVING不能用于應被用于WHERE子句的條目,不能編寫如下語句：
SELECT col_name FROM tbl_name HAVING col_name > 0;
--而應該這么編寫
SELECT col_name FROM tbl_name WHERE col_name > 0;

--HAVING子句可以引用總計函數，而WHERE子句不能引用：
SELECT user, MAX(salary) FROM users GROUP BY user HAVING MAX(salary)>10;

SELECT * FROM tbl LIMIT 10;  # Retrieve rows 0-9;
SELECT * FROM tbl LIMIT 5,10;  # Retrieve rows 6-15;

--如果要恢復從某個偏移量到結果集合的末端之間的所有的行，您可以對第二個參數是使用比較大的數。
--以下語句可以恢復從第96行到最后的所有行：
SELECT * FROM tbl LIMIT 95,18446744073709551615;