SELECT id,SUM(total) As SumTot FROM table-name GROUP BY id
ง่าย ๆ ครับ
Date :
2010-07-22 14:26:31
By :
webmaster
No. 2
Guest
มันดึงมาจาก 2 table ครับ
select r.itemcode,sum(o.docTotal) as sum from oinv o inner join inv1 r on o.docentry=r.docentry inner join oitm m on r.itemcode=m.itemcode inner join oslp s on o.slpcode=s.slpcode "
strSQL = strSQL & " where o.DocDueDate BETWEEN '"&Request.QueryString("date1")&"' and '"&Request.QueryString("date2")&"' and s.slpcode='"&Request.QueryString("SlpCode")&"' GROUP BY r.itemcode
มันไม่ได้ครับ
Date :
2010-07-22 15:02:43
By :
มือใหม่
No. 3
Guest
SELECT (IFNULL( `code` , "Total" ) ) AS me, sum( total ) AS you
FROM tmp
GROUP BY `code`
WITH ROLLUP
Load balance : Server 01
