62,046
社区成员
发帖
与我相关
我的任务
分享
select CONVERT(varchar(10),uc.pay_time,3) pay_time
,COUNT(*) xiaofeishuliang
,SUM(CONVERT(decimal(18,2),uc.amount)) xiaofeizongji
,SUM(CONVERT(decimal(18,2),uc.amount)) shijizongji
,SUM(CONVERT(decimal(18,2),uc.amount))/COUNT(*) renjun
from ucpayorder as uc
where uc.gameId=504002
group by uc.pay_time
/*
* -------------------------------------
* 楼主的:
* -------------------------------------
*/
select CONVERT(varchar(10),uc.pay_time,3) AS 'pay_time'
,COUNT(1) AS 'xiaofeishuliang'
,SUM(CONVERT(decimal(18,2),uc.amount)) AS 'xiaofeizongji'
,SUM(CONVERT(decimal(18,2),uc.amount)) AS 'shijizongji'
,AVG(CONVERT(decimal(18,2),uc.amount)) AS 'renjun'
from #TESTT AS uc
where uc.gameId=504002
group by uc.pay_time
/*
Msg 102, Level 15, State 1, Line 1
' ' 附近有语法错误。
找了半天反正没找到
*/
CREATE TABLE #TESTT(gameId INT IDENTITY(1,1) PRIMARY KEY,pay_time DATETIME,amount INT)
SELECT * FROM #TESTT
INSERT INTO #TESTT VALUES (GETDATE(),100)
SELECT CONVERT(VARCHAR(10),t.pay_time,3) AS 'pay_time',
COUNT(1) AS 'xiaofeishuliang' ,
SUM(CONVERT(DECIMAL(18,2),T.amount))AS 'xiaofeizongji',
SUM(CONVERT(DECIMAL(18,2),T.amount))AS 'shijizongji',
avg(CONVERT(DECIMAL(18,2),T.amount))AS 'renjun'
FROM #TESTT t
GROUP BY t.pay_time
GO
/*
* Result:
*
pay_time xiaofeishuliang xiaofeizongji shijizongji renjun
---------- --------------- ---------------- ----------------- ---------------
24/07/13 1 100.00 100.00 100.000000
(1 row(s) affected)
*/
没看出来哪里出错了。。