62,047
社区成员
发帖
与我相关
我的任务
分享
SELECT convert(varchar,sum(convert(money,A.amount)),1) as amot
FROM
(
SELECT TOP 40 *,
ROW_NUMBER() OVER ( ORDER BY sys_Test.st_Index ASC ) AS RowNumber
FROM transrecord where transstatus=2) A
WHERE A.RowNumber >20 AND A.RowNumber<41
SELECT convert(varchar,sum(convert(money,b.amount)),1) as amot
FROM(
SELECT TOP 20 * FROM
(SELECT TOP 40 * FROM transrecord where transstatus=2 ) AS a
ORDER BY a.ddid desc)
AS b
SELECT convert(varchar,sum(convert(money,b.amount)),1) as amot FROM(SELECT TOP 20 * FROM (SELECT TOP 40 * FROM transrecord where transstatus=2 ) AS a ORDER BY a.ddid desc) AS b