您所在位置：主题：PB问题求助!!急!!
烟雾缭绕
[专家分：0] 发布于 2005-08-16 09:58:00
我在PB数据窗口中用分组检索数据!!我想在每个分组只检索10条数据怎么实现??
下面是我在数据窗口下的SQL语句
select yfcfb.ksdm,yfcfb.ypbm,yfcfb.ypmc,yfcfb.ypgg,yfcfb.ypdw,yfcfb.dj,sum(yfcfb.sl)
from yfcfb ,kbdmb
WHERE convert(char(10),yfcfb.ksrq,102) between :rq1 and :rq2 and kbdmb.kbdm=yfcfb.ksdm and
(kbdmb.yybz =:yy or :yy='**')
group by yfcfb.ksdm,yfcfb.ypbm,yfcfb.ypmc,yfcfb.ypgg,yfcfb.ypdw,yfcfb.dj
下面是我在数据窗口下的SQL语句
select yfcfb.ksdm,yfcfb.ypbm,yfcfb.ypmc,yfcfb.ypgg,yfcfb.ypdw,yfcfb.dj,sum(yfcfb.sl)
from yfcfb ,kbdmb
WHERE convert(char(10),yfcfb.ksrq,102) between :rq1 and :rq2 and kbdmb.kbdm=yfcfb.ksdm and
(kbdmb.yybz =:yy or :yy='**')
group by yfcfb.ksdm,yfcfb.ypbm,yfcfb.ypmc,yfcfb.ypgg,yfcfb.ypdw,yfcfb.dj