SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (id int, name varchar(20), aka_name varchar(20))
insert into mytable values (1, 'Victor', 'vicky')
1 rows affected

insert into mytable values (1, 'Nicholas', 'nicki')
1 rows affected

insert into mytable values (1, 'Jefferson', 'jeff')
1 rows affected

select row_number() over(order by name) as id, name
from (
select name as name
from mytable
union all
select aka_name as name
from mytable) A


id
name


1
jeff

2
Jefferson

3
Nicholas

4
nicki

5
vicky

6
Victor