34,590
社区成员
发帖
与我相关
我的任务
分享请教一条SQL语句
SELECT KTPPMC, KTLXMC, XSSL, SJ, DID
FROM GL_KTXS_VIEW
WHERE (SJ = '2003-4-12') AND (KTPPMC = '格力') AND (KTLXMC = '窗机') AND (DID = 1)
我如何得到XSSL字段的总和？
在线等待！
FROM GL_KTXS_VIEW
WHERE (SJ = '2003-4-12') AND (KTPPMC = '格力') AND (KTLXMC = '窗机') AND (DID = 1)
我如何得到XSSL字段的总和？
在线等待！
...全文
请发表友善的回复…
发表回复
doudouniwan 2003-04-12
- 打赏
- 举报
SELECT KTPPMC, KTLXMC, sum(XSSL) xsslsum, SJ, DID
FROM GL_KTXS_VIEW
WHERE (SJ = '2003-4-12') AND (KTPPMC = '格力') AND (KTLXMC = '窗机') AND (DID = 1)
FROM GL_KTXS_VIEW
WHERE (SJ = '2003-4-12') AND (KTPPMC = '格力') AND (KTLXMC = '窗机') AND (DID = 1)
caiyunxia 2003-04-12
- 打赏
- 举报
SELECT SUM( XSSL) FROM GL_KTXS_VIEW
WHERE (SJ = '2003-4-12') AND (KTPPMC = '格力') AND (KTLXMC = '窗机') AND (DID = 1)
WHERE (SJ = '2003-4-12') AND (KTPPMC = '格力') AND (KTLXMC = '窗机') AND (DID = 1)
