List:General Discussion« Previous MessageNext Message »
From:Virgilio Quilario Date:March 28 2009 2:16pm
Subject:Re: succesive rows query
View as plain text  
> 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
Thread
succesive rows queryOguz Yarimtepe28 Mar
  • Re: succesive rows queryVirgilio Quilario28 Mar