是24个时段吧? SELECT DatePart(hour,Convert(datetime,operDate,120)) hour, SUM(GrosalAmt) Amount FROM dbo.pos_shift GROUP BY DatePart(hour,Convert(datetime,operDate,120))
SELECT DatePart(hour,Convert(datetime,operDate,120)) hour, SUM(GrosalAmt) Amount FROM dbo.pos_shift GROUP BY DatePart(hour,Convert(datetime,operDate,120))
34,590
社区成员
254,589
社区内容
加载中
试试用AI创作助手写篇文章吧