![]() Using Array_to_string function and array_agg function, we have combine the column rows using separator.Array_to_string function is basically used to combine the values from table column which was retrieve from array element by using the array_agg function in PostgreSQL.Above figure shows that we are using array_agg function on name column after using this function on name column it will only display all values from the column in array element format.Select id, array_agg(name) from stud2 group by id Using this function we are retrieving the column array elements value.īelow example shows that after using array_agg function we can only retrieve the array elements from the column. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |