Hi Friends,
I am new to SQL 2005,I need small help in writing a query.
I have a table as below
Col1(varchar) Col2 (bit)
Ramu 1
Raju 0
Ravi 1
Mohan 1
Sham 0
Sayed 1
From the above table I need to only those rows which are not in sequence.
Means if the previous row is '1' ,the next row should be '0'.If it is not '0'then I need to get that row.If it is '1' then no need to get that row.
Can any one please help me in this .
Thanks in Advance
