支付宝赞助帐号:service@kuitao8.com 

sqlite时间group by

Created2020-03-19   Views 32    Author 懒人程序
select strftime('%Y',datetime(actime, 'unixepoch', 'localtime')) as year,sum(acmoney) as money  from account group by strftime('%Y',datetime(actime, 'unixepoch', 'localtime'))
上一篇: mysql算出两经纬度的距离
下一篇:没有了
支持键盘 ← →

邮件订阅

订阅我们的精彩内容