select numbers,eveid,eveidname,invoice,invoicetype,submiterid,submiteridname,doctype,doctypename,Count(numbers) AS 订单数,SUM(amount) As totalamount fr om {pm0102} GROUP BY numbers,eveid,eveidname,invoice,invoicetype,submiterid,submiteridname,doctype,doctypename
select numbers,eveid,eveidname,invoice,invoicetype,submiterid,submiteridname,doctype,doctypename,Count(numbers) AS 订单数,SUM(amount) As totalamount fr om {pm0102} GROUP BY numbers