select COUNT(*) AS '交易量',DATEPART(hh,CDate) as '小时'
from PG_Txn
WHERE
CDate>=convert(varchar(10),GETDATE(),120)
and CDate <convert(varchar(10),dateadd(day,1,getdate()),120)
from PG_Txn
WHERE
CDate>=convert(varchar(10),GETDATE(),120)
and CDate <convert(varchar(10),dateadd(day,1,getdate()),120)
group by DATEPART(HH,CDate):