Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HSQL equivalent for rownum?

 
Sridhar Thakkapan
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a oracle query which runs fine. It fetches rows from table, orders them by date, selects only top 10.

i have used rownum. It is also possible with rank and denserank. But i need to work in hsql as well. hsql does not support rownum

Kindly suggest .....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic