select re.* from ( select row_number over(partition by id) as row_num, name from table1 ) res 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.
