1. 查询所有记录 和 查询 非重复记录
语法:
SELECT [ALL | DISTINCT ]
All:返回所有记录
Distinct:返回非重复记录
针对获得的记录内的字段生效。
2. 案例:
(1)看下面图,我们发现查询到是很多重复的,如下:
![](https://images2015.cnblogs.com/blog/757858/201510/757858-20151016165058538-1349232823.jpg)
(2)使用Select—distinct,如下:
![](https://images2015.cnblogs.com/blog/757858/201510/757858-20151016165137944-1048443141.jpg)
(3)select * from / select distinct * from
![](https://images2015.cnblogs.com/blog/757858/201510/757858-20151016165228335-189688409.jpg)
(4)select days,begin_date from teacher_class / select distinct days, begin_date from teacher_class
![](https://images2015.cnblogs.com/blog/757858/201510/757858-20151016165314163-1540247253.jpg)