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