Question

SQl 错误：在关键字 'AND' 附近有语法错误。

String sql = "SELECT MAX(t) AS F83max FROM (SELECT SUM(F83) AS t FROM FjGfbData WHERE ((Dev_id = 22) OR (Dev_id = 23) OR (Dev_id = 24) OR (Dev_id = 25) OR (Dev_id = 26))) AND (FG_date = '"
+statDate+"')";

Answer 1

String sql = "SELECT MAX(t) AS F83max FROM (SELECT SUM(F83) AS t FROM FjGfbData WHERE ((Dev_id = 22) OR (Dev_id = 23) OR (Dev_id = 24) OR (Dev_id = 25) OR (Dev_id = 26)) AND (FG_date = '"
+statDate+"'))";

AND 前的一个反括号要放到最后面

Answer 2

String sql = "SELECT MAX(t) AS F83max FROM (SELECT SUM(F83) AS t FROM FjGfbData WHERE ((Dev_id = 22) OR (Dev_id = 23) OR (Dev_id = 24) OR (Dev_id = 25) OR (Dev_id = 26)) AND (FG_date = '"
+statDate+"'))";
如上，AND前面多 了个右括号，应该放到最后

Answer 3

写的好麻烦：直接这样："String sql=SELECT MAX(t) AS F83max FROM (SELECT SUM(F83) AS t FROM FjGfbData WHERE Devid in（'22','23','24','25','26'） AND FG_date = '"+statDate+"')";

Answer 4

"AND " 改成 “WHERE”