本文介绍了一个复杂的SQL查询案例，该查询用于从多个表中提取指定日期前的数据，并按特定条件进行汇总。涉及到联表查询、子查询、条件筛选及聚合函数的使用。
[code]SELECT t0.googsB_id,
t1.NAME,
t1.code,
SUM(t0.num),
nvl(SUM(decode((SELECT substr(s.code,
0,
3)
FROM goodsA_type s
WHERE s.id =
t0.goodsA_type_id),
'aaa',
1,
'bbb',
-1) * t0.num * t0.price),
0) money
FROM goodsA t0,
goddsB t1
WHERE t0.goodB_id = t1.id AND
t0.accountant_date <=
To_date('2007-9-2',
'yyyy-mm-dd')
GROUP BY t0.goodB_id,
t1.NAME,
t1.code[/code]
t1.NAME,
t1.code,
SUM(t0.num),
nvl(SUM(decode((SELECT substr(s.code,
0,
3)
FROM goodsA_type s
WHERE s.id =
t0.goodsA_type_id),
'aaa',
1,
'bbb',
-1) * t0.num * t0.price),
0) money
FROM goodsA t0,
goddsB t1
WHERE t0.goodB_id = t1.id AND
t0.accountant_date <=
To_date('2007-9-2',
'yyyy-mm-dd')
GROUP BY t0.goodB_id,
t1.NAME,
t1.code[/code]
扫一扫
317
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
