Re: succesive rows query

[Virgilio Quilario]

> Hi,
>
> At my table i have fields a, b  and lets say i want to calculate the
> number of entries at the table which has the mentioned propery: if there
> are consecutive rows with a=x, b=y and the next line a=y and b=x but the
> third line should be a != x and b != y, is it possible with an sql query
> on mysql and where should i check to learn the how to?
>
> Thanx.

if you are trying to group results
look here
http://dev.mysql.com/doc/refman/5.0/en/select.html

virgil
http://www.jampmark.com