Re: Getting every other value in a select

2006-03-02 Thread Giuseppe Maxia
[EMAIL PROTECTED] wrote: > This might be a bit odd, but here we go.. > > I have some data in a table that has the following structure: > [SNIP] > The data is logged once a second. The StartTimeAndDate will be the same > for the particular workpiece that I am interested in. > I pull out the da

Re: Getting every other value in a select

2006-03-02 Thread SGreen
<[EMAIL PROTECTED]> wrote on 03/02/2006 06:55:14 AM: > This might be a bit odd, but here we go.. > > I have some data in a table that has the following structure: > > CREATE TABLE `gaugereportinglist` ( > > `Updated` timestamp NOT NULL default > CURRENT_TIMESTAMP on update