(jlive)[crashcourse]>SELECT products.prod_id,prod_name,prod_price FROM crashcourse.products;

+---------+----------------+------------+

| prod_id | prod_name      | prod_price |

+---------+----------------+------------+

| ANV01   | .5 ton anvil   |       5.99 |

| ANV02   | 1 ton anvil    |       9.99 |

| ANV03   | 2 ton anvil    |      14.99 |

| OL1     | Oil can        |       8.99 |

| FU1     | Fuses          |       3.42 |

| SLING   | Sling          |       4.49 |

| TNT1    | TNT (1 stick)  |       2.50 |

| TNT2    | TNT (5 sticks) |      10.00 |

| FB      | Bird seed      |      10.00 |

| FC      | Carrots        |       2.50 |

| SAFE    | Safe           |      50.00 |

| DTNTR   | Detonator      |      13.00 |

| JP1000  | JetPack 1000   |      35.00 |

| JP2000  | JetPack 2000   |      55.00 |

+---------+----------------+------------+

14 rows in set (0.00 sec)

排序并取前查询结果的前几项

(jlive)[crashcourse]>SELECT prod_id,prod_name,prod_price FROM products ORDER BY prod_price DESC,prod_id LIMIT 5;

+---------+--------------+------------+

| prod_id | prod_name    | prod_price |

+---------+--------------+------------+

| JP2000  | JetPack 2000 |      55.00 |

| SAFE    | Safe         |      50.00 |

| JP1000  | JetPack 1000 |      35.00 |

| ANV03   | 2 ton anvil  |      14.99 |

| DTNTR   | Detonator    |      13.00 |

+---------+--------------+------------+

5 rows in set (0.00 sec)

指定显示查询结果中的连续几行

(jlive)[crashcourse]>(jlive)[crashcourse]>SELECT prod_id,prod_name,prod_price FROM products ORDER BY prod_price DESC,prod_id LIMIT 1,3;

+---------+--------------+------------+

| prod_id | prod_name    | prod_price |

+---------+--------------+------------+

| SAFE    | Safe         |      50.00 |

| JP1000  | JetPack 1000 |      35.00 |

| ANV03   | 2 ton anvil  |      14.99 |

+---------+--------------+------------+

3 rows in set (0.00 sec)

等同于

(jlive)[crashcourse]>SELECT prod_id,prod_name,prod_price FROM products ORDER BY prod_price DESC,1 LIMIT 3 OFFSET 1;

+---------+--------------+------------+

| prod_id | prod_name    | prod_price |

+---------+--------------+------------+

| SAFE    | Safe         |      50.00 |

| JP1000  | JetPack 1000 |      35.00 |

| ANV03   | 2 ton anvil  |      14.99 |

+---------+--------------+------------+

3 rows in set (0.00 sec)

(jlive)[crashcourse]>SELECT vend_id FROM products;

+---------+

| vend_id |

+---------+

|    1001 |

|    1001 |

|    1001 |

|    1002 |

|    1002 |

|    1003 |

|    1003 |

|    1003 |

|    1003 |

|    1003 |

|    1003 |

|    1003 |

|    1005 |

|    1005 |

+---------+

14 rows in set (0.00 sec)

(jlive)[crashcourse]>SELECT DISTINCT vend_id FROM products;

+---------+

| vend_id |

+---------+

|    1001 |

|    1002 |

|    1003 |

|    1005 |

+---------+

4 rows in set (0.00 sec)

注释

注释单行

-- comments 或

# comments

注释多行

http://s1/mw690/002BYBFzgy70dBBVWlG50&690简单SELECT语句,排序及注释" TITLE="MariaDB 简单SELECT语句,排序及注释" />