我在mysql中有一个表,其中包含列inv_no,inv_date和total_amt。如何返回如下表格:-
--------------------------------------------
| Hourly | Transaction_Qty | Total_Amt |
--------------------------------------------
|00:00-00:59 |x |y |
|01:00-01:59 |x |y |
|02:00-02:59 |x |y |
|03:00-03:59 |x |y |
|and so on......
这是我的代码:
Dim query As String = "
SELECT COUNT(inv_no) AS TotalTransactionQty, SUM(total_amt) AS TotalAmount
FROM sales
GROUP BY DATE(inv_date)"
上面的代码只能按日期分隔,如何使用分组依据和之间将表格分隔为24行?
试试这个:
SELECT Hour(inv_date) As HourOfDay
, COUNT(inv_no) AS TotalTransactionQty
, SUM(total_amt) AS TotalAmount
FROM sales
GROUP
BY Hour(inv_date)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句