sql select statement to show multiple rows for a single row

• • Reply

  10 years ago

  by emceemic

  Michael Chang

  Toronto, Canada

  Joined 10 years ago

  Hello developers,

  I had a quick question with regards to selecting data to show multiple rows per row if required...... For example, say the table I currently have show the following data:

  Impact to Business Business Owner Name Breakdown Application John Doe Application Hardware Joe Smith Hardware Multiple John Doe 1:Hardware, 2: Application

  This is how the data is stored in the datatable itself. Is there a way I can SELECT this so that I can separate the 'Multiple' one to show individual info in different rows? ideally, the table I need is:

  Impact to Business Business Owner Name Breakdown Application John Doe Application Hardware Joe Smith Hardware Multiple John Doe 1:Hardware, 2: Application Hardware John Doe Hardware Application John Doe Application

  Thank you very much!

  Report abuse