SELECT
LEFT (bgn_time, 10) time,
FROM
LEFT (bgn_time, 10) time,
FROM
product
group by time , id
bgn_time 是2017-09-11 23:22:11的格式,我可以通过left切割前面十个字符,得到2017-09-11这种格式
group by 后面进行了两次分组
product
group by time , id
bgn_time 是2017-09-11 23:22:11的格式,我可以通过left切割前面十个字符,得到2017-09-11这种格式
group by 后面进行了两次分组