A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Head First Android
this week in the
JDBC and Relational Databases
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 .....
It is sorta covered in the
JavaRanch Style Guide
subject: HSQL equivalent for rownum?
JDBC2.0 feature. rs.absolute and relative( )
Selecting random rows
How to automate testing with database/web servers
Retrieving a subset of rows with SQL
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015