要求:筛选出符合条件的总条目数;
再进行分页查询限制。
难点:需要过滤符合多个列名的重复数据,再进行总条目数查询。
方法一:利用INTO的特性:插入前会将内表清空。
(PS:感觉还是会DUMP,一开始没有卡住数据量)
1、查询出总条目数:
SELECT
DISTINCT
列名1,列名2......列名n
FROM ztable AS z
INNER JOIN ekko
ON z~ebeln3 = ekko~ebeln OR z~ebeln2 = ekko~ebeln
INNER JOIN ekbe
ON ( z~ebeln3 = ekbe~ebeln AND z~ebelp3 = ekbe~ebelp ) OR ( z~ebeln2
= ekbe~ebeln AND z~ebelp2 = ekbe~ebelp )
LEFT JOIN vbkd
ON z~vbeln = vbkd~vbeln
WHERE
ekbe~budat BETWEEN @i_datestart AND @i_dateclose
AND
( z~idnrk LIKE 'A%' OR z~idnrk LIKE 'B%')
AND
ekbe~elikz = 'X'
AND
( ekbe~bwart = '1' OR ekbe~bwart = '2' OR ekbe~bwart = '9'
OR ekbe~bwart = '11' OR ekbe~bwart = '12' OR ekbe~bwart = '13'