merge multi rows by duplicate name in sql server -

merge multi rows by duplicate name in sql server -

i have info soo big 50 one thousand name , have duplicate names , informations not completed need merge duplicate names help please ??! :/

photo link

fifty one thousand records quite little compared capabilities of mysql, don't worry overtaxing server.

just list of deduplicated names, can this:

select distinct `full-name` table order `full-name`

to seek build deduplicated table little more complex. there business rules involved in process have not shared us.

but can seek aggregating query.

select `full-name`, group_concat(distinct age order age) age, group_concat(distinct notes order notes) notes table grouping `full-name`

sql sql-server sql-server-2008