I’ve 2 columns on the SQL data

URL    Title 

But, the issue is that there are duplicate URLs in the sheet and different titles


example.com  xyzzy
example.com  abac
example.com  mnop
example.com  pqrst
example.com  vamp

Now, what I want as an outcome

example.com xyzzy

Example.com/1  title 1
               title 2
               title 3
               title 4
               title n
  • This makes no sense on MySQL side - do this (remove below if the same exists above) on the client side using its reporting component. – Akina Nov 15 at 9:28
  • SQL Server or PostgreSQL? those are two very different databases – a_horse_with_no_name Nov 15 at 9:30
  • Akina is right. This kind of output formatting should be done by your application. That's not what SQL is intended for. – a_horse_with_no_name Nov 15 at 9:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.