File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HSQL equivalent for rownum?

 
Sridhar Thakkapan
Greenhorn
Posts: 1
  • 0
  • 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 .....
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic