Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | 51CTO学院 | CSDN程序员研修院 | OSChina 博客 | 腾讯云社区 | 阿里云栖社区 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏多维度架构

第 62 章 SQL Statement Syntax

Structured Query Language

目录

62.1. DISTINCT
62.2. group by
62.3. HAVING
62.4. REGEXP
62.5. IN / NOT IN
62.6. ALL / Any
62.7. exists, not exists
62.8. UNION
62.8.1. UNION ALL
62.8.2. 两张表字段不对等解决方法
62.9. OUTFILE/LOAD DATA INFILE
62.9.1. Export data to CSV from MySQL
62.9.2. Import data from CSV file.
62.10. CASE Syntax
62.11. 查询结果放入变量
62.12. MySQL 专有命令
62.12.1. SQL_NO_CACHE
62.12.2. SIGNAL Syntax
62.13. SQL 92

62.1. DISTINCT

SELECT DISTINCT user.name FROM user

SELECT DISTINCT user.name FROM user