如何过滤掉MySQL返回的结果集的行中的重复项？
通过在SELECT子句中使用DISTINCT关键字，这是可能的。DISTINCT适用于SELECT子句中指定的所有数据字段的组合。
示例
我们在表'Student'上应用了DISTINCT关键字，如下所示：
mysql> Select * from student; +------+---------+---------+-----------+ | Id | Name | Address | Subject | +------+---------+---------+-----------+ | 1 | Gaurav | Delhi | Computers | | 2 | Aarav | Mumbai | History | | 15 | Harshit | Delhi | Commerce | | 17 | Raman | Shimla | Computers | | 20 | Gaurav | Jaipur | History | +------+---------+---------+-----------+ 5 rows in set (0.00 sec) mysql> Select DISTINCT Address from student; +---------+ | Address | +---------+ | Delhi | | Mumbai | | Shimla | | Jaipur | +---------+ 4 rows in set (0.00 sec) mysql> Select DISTINCT * from student; +------+---------+---------+-----------+ | Id | Name | Address | Subject | +------+---------+---------+-----------+ | 1 | Gaurav | Delhi | Computers | | 2 | Aarav | Mumbai | History | | 15 | Harshit | Delhi | Commerce | | 17 | Raman | Shimla | Computers | | 20 | Gaurav | Jaipur | History | +------+---------+---------+-----------+ 5 rows in set (0.00 sec) mysql> Select DISTINCT name from student; +---------+ | name | +---------+ | Gaurav | | Aarav | | Harshit | | Raman | +---------+ 4 rows in set (0.00 sec)
热门推荐
4 万寿祝福语简短
10 妈妈祝福语简短16字
11 幼儿狗年祝福语大全简短
12 出阁祝福语简短句子
13 校长退休文案祝福语简短
14 红颜生日祝福语简短独特
15 端午发给客户祝福语简短
16 男朋友祝福语简短新年
17 妈妈给宝贝祝福语简短
18 工厂祝福语简短的句子