GROUP_CONCAT, LISTAGG or some other name, depending on the SQL dialect, is an aggregation function which takes values from several rows and lists them in a single string, separated by some pre-defined ...

Group_concat will always return a string value . it can be easily explain by the example.example: bookid | bookname | isbnno | cateid | autid | pubid | bk001 ...