Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql group_concat

GROUP_CONCAT() VS STRING_AGG() 

SELECT CustName, Address, GROUP_CONCAT(Address, ' || ') As CustAddress  FROM  Customers Group By CustName
#Group_Concat() may not work 2018 and upgraded version 
#SQL and MySQL same 

SELECT CustName, Address, STRING_AGG(Address, ' || ') As CustAddress  FROM  Customers Group By CustName
#String_Agg() may not work some SQL version 
#SQL and MySQL same 

#KindHeartedRamesh
 
PREVIOUS NEXT
Tagged: #sql
ADD COMMENT
Topic
Name
2+8 =