How to concatenate table columns in SQL

Kailash Singh

How to concatenate table columns in SQL

Published Jul 12,2023 by Kailash Singh

0 Comment     948 Views    


In this post, we are going to teach you how to concatenate tabe coums in SQL.

 

Example: 

select GROUP_CONCAT(COLUMN_NAME) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='users';

 

Result:

 

 


Comments ( 0 )