SELECT ORDERNO,SEIMEI,rtrim(ZUBAN) AS ZUBAN,KUMIYMD,sum(SEISU) as TOTAL
FROM [TD_SNFFIX]
where KUMIYMD between $para6 and $para5
group by ORDERNO,ZUBAN,SEIMEI,KUMIYMD
SELECT ORDERNO,SEIMEI,rtrim(ZUBAN) AS ZUBAN,KUMIYMD,sum(SEISU) as TOTAL FROM [TD_SNFFIX] where KUMIYMD between '${para6}' and '${para5}' group by ORDERNO,ZUBAN,SEIMEI,KUMIYMD
SELECT ORDERNO,SEIMEI,rtrim(ZUBAN) AS ZUBAN,KUMIYMD,sum(SEISU) as TOTAL FROM [TD_SNFFIX] where KUMIYMD between ${para6} and ${para5} group by ORDERNO,ZUBAN,SEIMEI,KUMIYMD