sql - Group BY on Condition basis -

sql - Group BY on Condition basis -

i have info in next way....

columna columnb 7675 22838 7675 24907 7675 null

i want results in next way.....

columna columnb 7675 2 (need total count not null value) 7675 0 (need count 0 null value)

select columna, count(columnb) columnb yourtable grouping columna union select columna, 0 yourtable columnb null grouping columna

sql sql-server