Here is my case , I have a database table with below fields

name
place_code
email
phone
address
details
estd
others

and example data

if you look at the above example table

First three records are talking about XYZ and place code 1020 .

I want create a single record for these three records based on

substring(name,1,4) 
place_code 

( I am lucky here for all the similar records satisfies this condition and unique in the table .)

For the other columns which record column length has max . For example again for the above 3 records email should be [email protected] , phone should be 657890 and details should be "testdetails"

This should be done for all the table . (Some has single records and some has max 10 records )

Any help on query that helps me to get the desired result ?

Thank You

Regards

Kiran