group by
#查询 group by col是将符合where条件的记录按特定的col进行分组,然后使用聚合函数对组进行统计;
#count(*)打印出每组的记录数;
#min(*),*打印出组内col最小的行;max与min同理。
#sum(col):计算出组内的col列的总和
#avg(col):计算出组内col列的平均值
SELECT MIN(createDate) AS sums,id FROM tb_inform a WHERE a.`original` ='13' GROUP BY TYPE ;
#select * from tb_inform a ;