Hot answers tagged


From the answers in the comments: 1. In order to concatenate unique values with group by clause: group_concat(distinct Locality) Order by: 2. Data ordering (by the data sample link from comment): From your data, it looks like that the start/End chainage fields are connected with the direction & order so this looks the most promising sql (see image): ...

Only top voted, non community-wiki answers of a minimum length are eligible