Re: 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.

select ... from table_name SAMPLE(0.2)

Above stmt select _approximately_ 0.2 percent of the rows of table_name.

Hth
Rene

-- 
  Rene Nyffenegger
  www.adp-gmbh.ch