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