本文探讨了SQL查询中的一些实用技巧，包括使用GROUP BY进行数据聚合的不同方式，以及如何通过FROM_UNIXTIME转换时间戳格式。
select * from test group by left(time,2);
select * from test group by name,time;
select from_unixtime(time,'%Y%m%d'),id,name from test;
select * from test group by time having count(time)>1;
select * from test group by left(time,2);
select * from test group by name,time;
select from_unixtime(time,'%Y%m%d'),id,name from test;
select * from test group by left(time,2);
select * from test group by name,time;
select from_unixtime(time,'%Y%m%d'),id,name from test;
转载于:https://my.oschina.net/0815/blog/65039
扫一扫
34万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
