17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT sum(item_real) From(SELECT item_real FROM budgetcontrol WHERE department = fi LIMIT 0 , 6)A
--oracle中不支持mysql中的limit分页,你可以使用rownum试试:
select sum(item_real)
from (
select item_real,rownum as rn
from budgetcontrol
department=fi
)
where rn>0 and rn<6;
select sum(item_real)
from budgetcontrol
where department=fi and
rownum<=6;