本文共 682 字，大约阅读时间需要 2 分钟。

???????????DISTINCT???

????????DISTINCT??????????????????????????????????????????DISTINCT????????????????????

DISTINCT???????????????????????????????????????????DISTINCT?????????????????????

2. SELECT????DISTINCT????

?SQL????DISTINCT???SELECT??????????SELECT?????DISTINCT??????

SELECT [distinct] columnName [from table]

???????DISTINCT?????????????????????????????????

3. ????????

3.1 ?????

SELECT distinct name FROM table

3.2 ?????id

SELECT distinct name, id FROM table

4. DISTINCT?????
• ???????????
• ???????????
• ?GROUP BY????????????????????
5. ????
• DISTINCT???????????????????????????
• ????????DISTINCT??????????????????????????

???????????DISTINCT??????????????????????????????????