ÓÅ»¯SQLÓï¾äµÄÎÊÌâ

±íTABLENAME£¬ÁÐMOVALUE M1VALUE ¡­¡­ M11VALUE£¬staticdate,stationid
ÐèÇóÊÇ
SELECT COUNT(M0VALUE) from TABLENAME WHERE M0VALUE!=0 AND M0VALUE IS NOT NULL and month(staticdate)=@month and stationid = @stationid
SELECT COUNT(M1VALUE) from TABLENAME WHERE M0VALUE!=0 AND M0VALUE IS NOT NULL and month(staticdate)=@month and stationid = @stationid

¡­¡­
SELECT COUNT(M11VALUE) from TABLENAME WHERE M0VALUE!=0 AND M0VALUE IS NOT NULL and month(staticdate)=@month and stationid = @stationid

È»ºóÔÚ°ÑÕâ11ÌõÖµÏà¼Ó¡£
µ«Ô·ÝÓÐ3¸ö£¬stationidÓжà¸ö¡£ÕâÑùµÄ»°¾ÍÐèÒªÖ´ÐÐN*11´ÎSQLÓï¾ä£¬ÕâÑùÐÔÄÜÌ«µÍÁË¡£ÓÐûÓÐʲôºÃ°ì·¨¿ÉÒÔ²»Ó÷Ö11´ÎÈ¥Ö´ÐУ¬Ò»´Î¾Í¿ÉÒÔ°ÑÕâ11ÁÐÇó³ö²¢Ïà¼Ó£¿
²»ÖªµÀÎÒ±í´ïÊÇ·ñ¹»Ã÷°×£¬Íû¸÷λ´óÏÀ´Í½Ì°¡£¡

---

SQL code:
SELECT COUNT(M0VALUE)+COUNT(M1VALUE) +COUNT(M11VALUE) ..............
from TABLENAME WHERE M0VALUE!=0 AND M0VALUE IS NOT NULL and month(staticdate)=@month and stationid = @stationid
???????

---

SQL code:
[code=SQL]
--try
SELECT COUNT(M1VALUE)+COUNT(M1VALUE)+COUNT(M2VALUE)....COUNT(M11VALUE) from TABLENAME WHERE M0VALUE!=0 AND M0VALUE IS NOT NULL and month(staticdate)=@month and stationid = @stationid
[/code]

---

SELECT COUNT(*) from TABLENAME
WHERE M0