DIstinct理解
参考:https://blog.csdn.net/lmy86263/article/details/73612020
由来
SELECT
a.f_is_regular,
a.f_review_time,
DISTINCT(a.unit_id),
a.monitor_time,
a.unit_name,
a.id,
datediff( a.f_review_time,a.monitor_time) as disposeTimeDiff
FROM
`event-dispose`.`event_alarm_info` a
WHERE
sub_center_code = '3345';
上面sql报错信息:
用法:
最核心!!!!就是:
当
distinct
应用到多个字段的时候,其应用的范围是其后面的所有字段,而不只是紧挨着它的一个字段,而且distinct
只能放到所有字段的前面
#下面这行将distinct放在所有字段最前方,代表根据unit_id,is_regular,review_time等等6个字段一起判断非重复。
SELECT
DISTINCT
a.unit_id,
a.f_is_regular,
a.f_review_time,
a.monitor_time,
a.unit_name,
a.id,
datediff( a.f_review_time,a.monitor_time) as disposeTimeDiff
FROM
`event-dispose`.`event_alarm_info` a
WHERE
sub_center_code = '3345';
#但是现在我将第一个字段进行小括号包起来,x
SELECT
DISTINCT(a.unit_id),
a.f_is_regular,
a.f_review_time,
a.monitor_time,
a.unit_name,
a.id,
datediff( a.f_review_time,a.monitor_time) as disposeTimeDiff
FROM
`event-dispose`.`event_alarm_info` a
WHERE
sub_center_code = '3345';
_alarm_info` a
WHERE
sub_center_code = ‘3345’;