SELECT in_id FROM JXCATV_INDEVICE WHERE in_date >= #" + st + "# AND in_date <= #" + et + "# group by in_id 这样就好了,记住用Group By前面不能用* ,只能是Group By的字段或者是聚合函数
SELECT in_id FROM JXCATV_INDEVICE WHERE in_date >= #" + st + "# AND in_date <= #" + et + "# group by in_id#号是什么,用单引号,
这样就好了,记住用Group By前面不能用* ,只能是Group By的字段或者是聚合函数
FROM JXCATV_INDEVICE
WHERE in_date >= #" + st + "# AND in_date <= #" + et + "# group by in_id#号是什么,用单引号,