how to select every "n"th row from an ordered dataset?

microsoft.public.sqlserver.programming

24 Apr 2007 10:58 PM

Rich

My table contains 100 rows of data that was collected every 10 seconds. The
datetime is recorded along with other information. I want to retrieve every
6th row from this table - that would be the row at each minute interval. How
to accomplish this?

pseudo code here

select * from mytbl Where "Timefield is 1 minute apart" Order by Timefld

Thanks,
Rich