不是聚合函数,也没有分组子句导致的错误,改如下: SELECT Person_No,Op_Date,Op_Time FROM SaveMoneyInfo WHERE Person_No = '0000001' order by Op_Date desc group by 0/ID
ID表示主键,自动增长字段,把ID改成你的自增长字段
SELECT Person_No,Op_Date,Op_Time FROM SaveMoneyInfo WHERE Person_No = '0000001' order by Op_Date desc 上面的语句我在 jbuilder 7 的database pilot 中执行正确, 但是在jsp中不正确 如果去掉 order by SaveMoneyInfo.Op_Date desc 结果正确
检查程序及运行环境。
SELECT Person_No,Op_Date,Op_Time FROM SaveMoneyInfo WHERE Person_No = '0000001' order by Op_Date desc group by 0/ID
但是在jsp中不正确
如果去掉 order by SaveMoneyInfo.Op_Date desc 结果正确