SharuPoNemnogu

select id, 
           column1, 
           column2, 
           count(
                    case when column1 <> column2 
                    then 1 
                    else null end
           ) over(order by id) 
from table1;