sqlite排序SUM列值 [英] sqlite sorting SUM column values
本文介绍了sqlite排序SUM列值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT SUM(bytes),stamp_updated
from acct
where stamp_updated BETWEEN datetime('now', 'localtime','-7 hours') AND datetime('now', 'localtime')
GROUP BY ip_src
ORDER BY bytes DESC limit 10;
48498275|2012-04-09 11:26:01
6977282|2012-04-09 08:27:01
1192705|2012-04-09 08:46:02
3971336|2012-04-09 09:46:04
1909543|2012-04-09 11:28:04
265829|2012-04-09 09:11:02
1234909|2012-04-09 10:28:04
2396834|2012-04-09 11:28:02
192638|2012-04-09 09:00:01
30766141|2012-04-09 11:31:01
为什么第一列未正确排序(DESC)?
Why isn't the first column not getting sorted properly (DESC)?
推荐答案
在与bytes
列进行汇总之前,需要进行排序.试试这个:
You're ordering with your bytes
column before they are aggregated. Try this:
SELECT SUM(bytes) AS total_bytes, stamp_updated
FROM acct
WHERE stamp_updated BETWEEN datetime('now', 'localtime','-7 hours') AND datetime('now', 'localtime')
GROUP BY ip_src
ORDER BY total_bytes DESC limit 10;
这篇关于sqlite排序SUM列值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文