Need help with retriving RANDOM rows from a table.

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.

Please advise. Received on Tue Aug 12 2003 - 08:13:51 CDT