succesive rows query

2009-03-28 Thread Oguz Yarimtepe
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

Re: succesive rows query

2009-03-28 Thread 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