hibernate 在order by后不执行where语句

Question

[b] public List searchWorklogCount(){
return this.getHibernateTemplate().find("from worklog order by id desc where (logDate between '2011-04-21' and '2011-04-22')");
}[/b]

取出的是所有数据，如果把order by id desc去掉，变成：
[b]public List searchWorklogCount(){
return this.getHibernateTemplate().find("from worklog where (logDate between '2011-04-21' and '2011-04-22')");
}[/b]
则取出的是正确的数据。
在mysql中输入以上两个语句，取出均为正确的。
求教中......

Answer 1

return this.getHibernateTemplate().find("from worklog where (logDate between '2011-04-21' and '2011-04-22')")order by id desc
;
就ok啦！