select re.* from
select row_number over(partition by id) as row_num, name
where res.row_num = 1
it will return only distinct...
You need to translate varchar data in to another language by google translator then compare it with nvarchar data.
insert into table2
select count(*) from table1
Separate names with a comma.