Home | 简体中文 | 繁体中文 | 杂文 | 打赏(Donations) | OSChina 博客 | Facebook | Linkedin | 知乎专栏 | Search | About

第 6 章 SQL Statement Syntax

Structured Query Language

目录

6.1. DISTINCT
6.2. group by
6.3. HAVING
6.4. REGEXP
6.5. IN / NOT IN
6.6. ALL / Any
6.7. exists, not exists
6.8. UNION
6.8.1. UNION ALL
6.9. OUTFILE/LOAD DATA INFILE
6.9.1. Export data to CSV from MySQL
6.9.2. Import data from CSV file.
6.10. CASE Syntax
6.11. MySQL 专有命令
6.11.1. SQL_NO_CACHE
6.11.2. SIGNAL Syntax
6.12. SQL 92

6.1. DISTINCT

SELECT DISTINCT user.name FROM user

SELECT DISTINCT user.name FROM user