สอบถามการ SELECT ข้อมูล ใน mysql เงื่อนไขที่ใช้ร่วมกับ GROUP BY ค่ะ
Code (SQL)
$strSQL="SELECT date,IDname , SUM(red) as s_red , SUM(white) as s_white FROM summary GROUP BY date,IDname";
Date :
2015-12-03 21:23:42By :
ipstarone
Code (PHP) $strSQL="SELECT date,IDname , SUM(red) as s_red , SUM(white) as s_white FROM summary GROUP BY date,IDname";
Date :
2015-12-04 08:51:19By :
sammam
ได้แล้วค่ะ Code (PHP) $strSQL="SELECT date,IDname , SUM(red) as s_red , SUM(white) as s_white FROM summary GROUP BY YEAR(date) ,IDname HAVING YEAR(date) = ".$keyword." ";
Date :
2015-12-04 11:28:49By :
sammam
Server 00
Load balance : Server 00
