Horje
get comma separated values in mysql with group by Code Example
get comma separated values in mysql with group by 
SELECT p.id, p.name, GROUP_CONCAT(s.name) AS site_list
FROM sites s
INNER JOIN publications p ON(s.id = p.site_id)
GROUP BY p.id, p.name;
Source: stackoverflow.com



Sql

Related
check constraint is violated Code Example check constraint is violated Code Example
recursive query herarchical data sql server Code Example recursive query herarchical data sql server Code Example
Run batch file from SQL Code Example Run batch file from SQL Code Example
selecting names ending with vowels in sql Code Example selecting names ending with vowels in sql Code Example
NLS_NCHAR_CHARACTERSET Code Example NLS_NCHAR_CHARACTERSET Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje