mysql的distinc怎么用_mysql distinct 使用方法及实例介绍

先给出本文章需要使用到的数据表：

mysql> select * from Employee;

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

| id | first_name | last_name | city | description |

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

| 1 | Jason | Martin | Toronto | Programmer |

| 2 | Alison | Mathews | Vancouver | Tester |

| 3 | James | Smith | Vancouver | Tester |

| 4 | Celia | Rice | Vancouver | Manager |

| 5 | Robert | Black | Vancouver | Tester |

| 6 | Linda | Green | New York | Tester |

| 7 | David | Larry | New York | Manager |

| 8 | James | Cat | Vancouver | Tester |

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

8 rows in set (0.00 sec)

比如我们要查询这张表中不同的city的具体的值，此时可以使用mysql distinct语句实现：

mysql> SELECT DISTINCT city FROM Employee;

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

| city |

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

| Toronto |

| Vancouver |

| New York |

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

3 rows in set (0.00 sec)

注意mysql中distinct语句必须放在开头，下面写会报mysql错误：

mysql> SELECT id,DISTINCT city FROM Employee;

下面写法是正确的：

mysql> SELECT DISTINCT city id,FROM Employee;