Untitled

New select column with a counter that increase depending on conditions in SQL
ID ||| COLUMN1 ||| COLUMN2 ||| COLUMN3 ||| COLUMN 4 |||NEW_COLUMN
1        null        null        null         12
2         13         null        null         18           1
3        null        null        null         82
4        null        null        null         81
5        null        null        31           89           2
6        null        22          32           91           3
7        null        92          null         95           4

SELECT COLUMN1,COLUMN2,COLUMN3,COLUMN4, (SELECT .....) FROM ... WHERE ...

select t.*, (@row := case
                     when column1 is not null or column2 is not null or column3 is not null
                     then @row
                     else null
            end) as NEW_COLUMN,
            (@row := case
                     when column1 is not null or column2 is not null or column3 is not null
                     then @row + 1
                     else @row
            end) as TEMP_COLUMN
from your_table t, (select @row := 0) r

select a.ID,a.COLUMN1,a.COLUMN2,a.COLUMN3,a.COLUMN4,COUNT(b.ID) from
(select * from <your_table> where coalesce(column1,column2,column3) is not null)a
join
(select * from <your_table> where coalesce(column1,column2,column3) is not null)b
on a.ID>=b.ID
group by a.ID,a.COLUMN1,a.COLUMN2,a.COLUMN3,a.COLUMN4
union all
select *,null from <your_table> where coalesce(column1,column2,column3) is null
order by id