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
Why isn't the first column not getting sorted properly (DESC)?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…