Home | 簡體中文 | 繁體中文 | 雜文 | 打賞(Donations) | Github | OSChina 博客 | 雲社區 | 雲棲社區 | Facebook | Linkedin | 知乎專欄 | 視頻教程 | About

第 64 章 SQL Statement Syntax

Structured Query Language

目錄

64.1. DISTINCT
64.2. group by
64.3. HAVING
64.4. REGEXP
64.5. IN / NOT IN
64.6. ALL / Any
64.7. exists, not exists
64.8. UNION
64.8.1. UNION ALL
64.8.2. 兩張表欄位不對等解決方法
64.9. OUTFILE/LOAD DATA INFILE
64.9.1. Export data to CSV from MySQL
64.9.2. Import data from CSV file.
64.10. CASE Syntax
64.11. MySQL 專有命令
64.11.1. SQL_NO_CACHE
64.11.2. SIGNAL Syntax
64.12. SQL 92

64.1. DISTINCT

SELECT DISTINCT user.name FROM user

SELECT DISTINCT user.name FROM user