谁来帮我优化一下我的sql语句？？？

[dai2jiang]

语句如下：
select count(*) from
(select t.mobile tm,sum(t.jifen)ts from t_jifen_detail t
where t.jifen>0 group by t.mobile)A,
(select j.mobile jm,sum(j.jifen)js from t_jifen_detail j
group by j.mobile)B
where A.ts=B.js;

[xiaowanglinxiao]

偶的理解：是不是要求积分大于零t.mobile的个数
select count(*) from
(select t.mobile tm,sum(t.jifen)ts from t_jifen_detail t
where t.jifen>0 group by t.mobile)

这个应该就可以了呀~1

[daifeng130]

除非积分有小于0的，否则你要的结果好像就是
select count(distinct mobile) from t_jifen_detail
where jifen>0

[nicholasgunn]

select mobile ,sum(jifen) from
t_jifen_detail
where mobile not in (select mobile from t_jifen_detail where jifen<=0 and rownum=1)
group by mobile

---------------------------------------------------
select mobile ,sum(jifen) from
t_jifen_detail a
where not exists(select * from t_jifen_detail b where a.mobile=b.mobile and b.jifen<=0)
group by mobile

好久不写sql了，都快忘了，记的好像可以这么写，你试试吧。
个人感觉第1种靠谱儿。

[nicholasgunn]

好像有点问题，上面的“=”不应该有。

[hyrongg]

语法没问题，感觉逻辑有问题

你要的结果好像就是
select t.mobile tm,sum(t.jifen) ts,count(1) from t_jifen_detail t where t.jifen>0 group by t.mobile;

里面的count(1)的值
列点数据，说明你要的结果，再帮你看看

[caoleione]

Select Count(1)
From (Select j.Mobile Jm,
Sum(j.Jifen) Js,
Sum(Decode(Sign(Jifen), 1, Jifen, 0)) As Ts
From t_Jifen_Detail j
Group By j.Mobile)
Where Js = Ts