Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
JDBC and Relational Databases
HSQL equivalent for rownum?
posted 4 years ago
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
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