This topic has been archived. It cannot be replied.
-
工作学习 / 专业知识杂谈 / SQL 高手请帮忙!!
-memeling(Double M);
2006-3-24
{822}
(#2862940@0)
-
怎么没见a?
-markriver(markriver);
2006-3-24
(#2862960@0)
-
Should be "b". Sorry.
-memeling(Double M);
2006-3-24
(#2862987@0)
-
no where , having
-markriver(markriver);
2006-3-24
(#2863264@0)
-
master.d_date c,
不应该有这个 ","
-hard20(hard20);
2006-3-24
{567}
(#2863089@0)
-
好像还是不行.
-memeling(Double M);
2006-3-24
(#2863395@0)
-
没装Oracle,没法帮你试,看看这个好不好用吧...SELECT
b.member_id,
to_char(c.cal_dt,'mm'),
sum(a.value_amt) as total_spend
FROM
master.f_purchase_category b,master.d_date c
WHERE b.d_trans_date_key=c.d_date_key
and c.cal_dt >= to_date ('2006-01-01','yyyy-mm-dd')
and c.cal_dt < to_date ('2006-03-20','yyyy-mm-dd')
group by b.member_id, to_char(c.cal_dt,'mm')
-hard20(hard20);
2006-3-24
{332}
(#2863526@0)
-
remove "as flag" from the end should work
-tootoo(倚老卖老);
2006-3-27
(#2868162@0)
-
Solved.
THanks for your help.
-memeling(Double M);
2006-3-27
(#2868515@0)
-
怎么解决的也不说说?
-markriver(markriver);
2006-3-28
(#2870497@0)