• 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 .....
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!