A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
HSQL equivalent for rownum?
Joined: Apr 24, 2011
Aug 31, 2011 13:10:53
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 .....
I agree. Here's the link:
subject: HSQL equivalent for rownum?
Retrieving a subset of rows with SQL
JDBC2.0 feature. rs.absolute and relative( )
Selecting random rows
How to automate testing with database/web servers
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014