Hi, I have a table with a following data: Id No1 No2 ---------------- 1 1001 11 2 1002 11 3 1003 12 4 1004 12 5 1004 12 6 1005 12 7 1006 13 8 1007 13 9 1008 14 ... .... ...
Now, I would like to select only the rows when No2 change. So the result of such query should look like: Id No1 No2 ---------------- 1 1001 11 3 1003 12 7 1006 13 9 1008 14 ... .... ... How should this query look like? Regards Wojciech ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------