having rownum<=10
-->这是什么语发,不通,重写.
-->这是什么语发,不通,重写.
解决方案 »
- oracle编程、操作不良习惯总结
- Oracle导入数据后自动编号的问题
- 普通用户在使用grant select any table to username的时候提示权限不足
- OracleDBConsoleorcl无法启动
- 20分求SQL语句一条
- 棘手的触发器,请高手帮忙解决
- SQL2000转移到ORACLE的问题?
- 请大家帮我看看这段需求该怎么实现,。谢谢啦!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 如何知道一个数据库中有多少个表
- 新手请教一个关于数据类型问题
- 我还是不明白,这个回显是怎么回事?
- 请教!为何我把VFP中的表导入到oracle中后,在sql*plus用select看不到数据?在线等待
(select d.DIQUNAME,substr(b.bno,1,6) as bno,b.bname,b.price,
sum(b.amount) as amount,sum(b.mayang) as mayang
from sales a,sales_mx b,units c,diqus d
where a.sno=b.sno and a.uno=c.uno and c.diqu=d.diqu
and xsbz='1'
and to_char(a.sale_date,'yyyy-mm-dd')>='2003-03-01'
and to_char(a.sale_date,'yyyy-mm-dd')<='2003-03-31'
group by d.DIQUNAME,substr(b.bno,1,6),b.bname,b.price
order by d.DIQUNAME desc,substr(b.bno,1,6) desc,b.bname desc,b.price desc) tab
where tab.nownum<=10
select tab.zz,tab.bno,tab.yy,tab.xx,tab.amount,tab.mayang from
(select d.DIQUNAME zz,substr(b.bno,1,6) bno,b.bname yy,b.price xx,
sum(b.amount) amount,sum(b.mayang) mayang
from sales a,sales_mx b,units c,diqus d
where a.sno=b.sno and a.uno=c.uno and c.diqu=d.diqu
and xsbz='1'
and to_char(a.sale_date,'yyyy-mm-dd')>='2003-03-01'
and to_char(a.sale_date,'yyyy-mm-dd')<='2003-03-31'
group by d.DIQUNAME,substr(b.bno,1,6),b.bname,b.price
order by d.DIQUNAME desc,substr(b.bno,1,6) desc,b.bname desc,
b.price desc) tab
where tab.nownum<=10
where tab.nownum<=10改为:
where rownum<=10。
程序运行没错,但有一个问题,只取了10条纪录,而不是每个地区取10条纪录。
insert into cdz_dqtstjb(DIQUNAME,bno,bname,price,amount,mayang)
select tab.zz,tab.bno,tab.yy,tab.xx,tab.amount,tab.mayang from
(select d.DIQUNAME zz,substr(b.bno,1,6) bno,b.bname yy,b.price xx,
sum(b.amount) amount,sum(b.mayang) mayang
from sales a,sales_mx b,units c,diqus d
where a.sno=b.sno and a.uno=c.uno and c.diqu=d.diqu
and xsbz='1'
and to_char(a.sale_date,'yyyy-mm-dd')>='2003-03-01'
and to_char(a.sale_date,'yyyy-mm-dd')<='2003-03-31'
and d.DIQUNAME='丰台区'
order by d.DIQUNAME desc,substr(b.bno,1,6) desc,b.bname desc,b.price desc) tab
where nownum<=10把'丰台区'改为你知道的区,有几个区就执行几次吧。