Db2 grouping for other data splicing-CodePudding

Home > database > Db2 grouping for other data splicing

Db2 grouping for other data splicing

Time：09-17

Select id, listagg (columnName) from tb_name group by f_id -- -- -- -- -- -- -- -- -- -- -- -- db2
Select id, group_concat (columnName) from tb_name group by f_id -- -- -- -- -- -- -- -- -- -- -- -- mysql

Page link：https//www.codepudding.com/database/6029.html

Prev:Greenplum select query the current time now () is always less than the time of 12 hours, the server

Next:Refer to how the SQL through the same field to screen display only a (duplicate), query the two tabl

Tags：

DB2

Links：
CodePudding