UC知道jsp下sql语言问题
来源：百度知道 编辑：UC知道 时间：2024/06/30 06:32:24
jbuilder提示下面的程序where处出错？怎么改？
String sqli=" SELECT * FROM manager order by times desc WHERE times>0 ";
String sqli=" SELECT * FROM manager order by times desc WHERE times>0 ";
order by
group by
都需要放到where条件的后边
String sqli=" SELECT * FROM manager where times>0 order by times desc ";
看看对不
可以啊
你的order by 写反拉，应该写在where 的子句后边