List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:January 27 2005 2:50pm
Subject:RE: How to select every second record
View as plain text  
[snip]
Jay Blanchard wrote:
> [snip]
> Is it possible to select only every second record from a record set?
>  
> I should select the record-number 1, 3, 5, 7, 9, ... or record-number
2,
> 4,
> 6, 8, ...
>  
> Can this be done with LIMIT?
> [/snip]
> 
> Not LIMIT, but you can use MOD, especially with an auto-increment
field
> (id in this case is the auto-increment field)
> 
> select * from table where mod(id, 2) <> '0' returns odd rows
> select * from table where mod(id, 2) <> '1' returns even rows
> 
You have to do it with LIMIT
beacuse id may not help you...
so
select * from table where <condition> [group by <field>]
  [order by <field> [desc]] LIMIT 2,1

this select just second resultrow from any kind of resultset made using 
every thing you like in where/order by/groub by and not being limited by

  using IDs (auto_increment)
[/snip]

The problem is that this only returns ONE record, the OP wanted every
other record
Thread
How to select every second recordMartin Rytz27 Jan
  • Re: How to select every second recordMartijn Tonies27 Jan
RE: How to select every second recordJay Blanchard27 Jan
RE: How to select every second recordJay Blanchard27 Jan
  • RE: How to select every second recordGordon27 Jan
RE: How to select every second recordJay Blanchard27 Jan