一个简单的SQL

iguana · 发表于 2004-12-3 17:22

Select a.custno, a.count, a.je, a.jf
From
(select rownum rowid,* from
(select custno,count(sxje) count,sum(sxje) je,sum(it_xfjf) jf
from cust_sp_rz
where rqsj>='01-may-04' and rqsj<='10-oct-04'
group by custno
order by count desc) ) a
Where a.rowid<100

不能加orderby了，否则会出错！

kicksoccer · 发表于 2004-12-3 17:24

还是在子查询的orderby子句报错：ORA-00907: missing right parenthesis

robin · 发表于 2004-12-3 17:34

最初由 stuv 发布
[B]select * from
(select custno,count(sxje) count,sum(sxje) je,sum(it_xfjf) jf
from cust_sp_rz
where rqsj>='01-may-04' and rqsj<='10-oct-04'
group by custno
order by count desc)
where rownum <=xx; [/B]

子查询相当于视图，在8i后的版本中才能使用。