Concat different rows column into single row field

  • Thread starter Thread starter troppfigo
  • Start date Start date
T

troppfigo

Suppose u have a view made out of some tables, which results in a table
like givin this present output

see down.. data in TABLES

PRESENT OUTPUT

ID Name Dependents day
712 Manish Sudha Monday
712 Manish Sudha Friday
712 Manish Sudha Sunday


REQUIRED OUTPUT

ID Name Dependents day
712 Manish Sudha Monday,Friday,Sunday


Here in the output required (ID is the primary key), I want all days to
be printed in the same row concatenated by ,

Can you help me?please.
Can you post some examples.
 
Back
Top