This case is related to case number 2022-00019: DSOURCE ONLINE TRAINING - "INTRODUCTION TO ACTIAN X AND INGRES SQL" - BATCH 5\n\nDuring the training one of the HDMF participants asks if ingres has a GROUP_CONCAT() function just like in MySQL.\n\nGROUP_CONCAT() SYNTAX:\n\n\tGROUP_CONCAT(expr);\n\nSAMPLE:\n\t\n\tSELECT\tpub_id,\n\t\tGROUP_CONCAT(DISTINCT cate_id)\n\tFROM book_mast\n\tGROUP BY pub_id\n\tORDER BY GROUP_CONCAT(DISTINCT cate_id) ASC;\n\nFor more information about GROUP_CONCAT() go to this link:\nhttps://www.w3resource.com/mysql/aggregate-functions-and-grouping/aggregate-functions-and-grouping-group_concat.php\n