• Post Reply Bookmark Topic Watch Topic
  • New Topic

HSQL equivalent for rownum?  RSS feed

 
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
Boost this thread!