****简单问题******

[pawly]

select distinct s.mat_no
from s1_req_list s
group by s.mat_no
where sum(s.mat_num) > 0;
为什么不对，错在那

[三杯倒]

错在条件。

[pawly]

那怎样加条件

[wzyun]

select distinct s.mat_no,sum(s.mat_num)
from s1_req_list s
group by s.mat_no
HAVING sum(s.mat_num) > 0;

[kind_li]

wzyun(空白)　是对的，给他加分吧

[wzyun]

select distinct s.mat_no,sum(s.mat_num)
from s1_req_list s
group by s.mat_no
having sum(s.mat_num) > 0;

[咖啡]

wzyun(空白)是对的,我来晚了.