Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help with retriving RANDOM rows from a table.
LT Cheah schrieb:
> I would like to retrieve only a certain number of rows from a table (of
> production data) for statistical analysis of certain production test
> parameters.
>
> The table has say 1 million rows and has a Date_Time column with a date
> format. How does one relive say the first 20 rows of data for every hour
> for example.
>
> Or is there any other simpler method (by using the ROW_ID for example) such
> that a limited random number of rows may be retrived.
>
Statement.setMaxRows() is what you are looking for:
<http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#setMaxRows(int)>
Thomas Received on Tue Aug 12 2003 - 08:39:41 CDT