> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
