|List:||General Discussion||« Previous MessageNext Message »|
|From:||Oguz Yarimtepe||Date:||March 28 2009 7:38am|
|Subject:||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.
|• succesive rows query||Oguz Yarimtepe||28 Mar|
|• Re: succesive rows query||Virgilio Quilario||28 Mar|