Hello,

A possible solution :

select 'column_with_null_value', column2 from your_table
where name is null
union
select name, column2 from your_table
where name is not null
order by name

Hope this helps

Regards