# 开始送分，只要能给思路

yxwgr 2001-11-26 10:19:31

...全文
88 10 打赏 收藏 举报

10 条回复

yxwgr 2001-11-27
• 打赏
• 举报

yxwgr 2001-11-27
• 打赏
• 举报

http://www.csdn.net/expert/topic/390/390021.shtm

yxwgr 2001-11-27
• 打赏
• 举报

(case when "qcjz_client"."money">0 then "qcjz_client"."money" else null) as 'ys',
case when "qcjz_client"."money">0 then "qcjz_client"."money" else null) as 'yf'
FROM "qcjz_client"

• 打赏
• 举报

select 方向* 金额 as 往来余额 from qcjz_client;

select sum(case 方向 then 金额 else 0) as 应收款发生额,
sum(case 方向 then 0 else 金额) as 应付款发生额
FROM qcjz_client
yxwgr 2001-11-26
• 打赏
• 举报

yubintj(皇上)：

http://www.csdn.net/expert/topic/390/390029.shtm

yubintj 2001-11-26
• 打赏
• 举报

lif_009 2001-11-26
• 打赏
• 举报

yxwgr 2001-11-26
• 打赏
• 举报

SELECT (sign("qcjz_client"."money")+1)*"qcjz_client"."money"/2 as 'ys',
(sign("qcjz_client"."money")-1)*"qcjz_client"."money"/2 as 'yf'
FROM "qcjz_client"

SELECT if("qcjz_client"."money">0,"qcjz_client"."money",0) as 'ys',
if("qcjz_client"."money"<0,"qcjz_client"."money",0) as 'yf'
FROM "qcjz_client"

yxwgr 2001-11-26
• 打赏
• 举报

fallstone 2001-11-26
• 打赏
• 举报

1028

PowerBuilder 相关问题讨论

2001-11-26 10:19