Rst=Stmt.executeQuery("select year(max(datetime)) as year1 ,month(max(datetime)) as month1,day(max(datetime)) as day1,year(min(datetime)) as year2 ,month(min(datetime)) as month2,day(min(datetime)) as day2 from by2a where station_name='"+station_name+"'");
Rst.next();提示
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]列 'by2a.id' 在选择列表中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。我也没用id啊,是不是我驱动的问题,我只是安装了ms的jdbc for sqlserver2000,没设环境变量什么的
Rst.next();提示
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]列 'by2a.id' 在选择列表中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。我也没用id啊,是不是我驱动的问题,我只是安装了ms的jdbc for sqlserver2000,没设环境变量什么的
没有就得要安装一下的