distinct关键字用于返回唯一不同的值。
例如:"orders表 如果执行sql语句:select company from orders
如果执行sql语句:select distinct company from orders
company | orderNumber |
baidu | 12 |
ALi | 34 |
baidu | 56 |
Tencent | 78 |
distinct关键字用于返回唯一不同的值。
例如:"orders表 如果执行sql语句:select company from orders
如果执行sql语句:select distinct company from orders
company | orderNumber |
baidu | 12 |
ALi | 34 |
baidu | 56 |
Tencent | 78 |