Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mariadb select multiple rows into one column

SELECT
	GROUP_CONCAT(DISTINCT id SEPARATOR ', ') AS 'ids'
FROM
	table_name
WHERE
	column_name = 'value'
Comment

PREVIOUS NEXT
Code Example
Sql :: ci last query 
Sql :: sql get missing id 
Sql :: dbms output 
Sql :: starts and end with vowel sql 
Sql :: alter table column size oracle 
Sql :: sql server read uncommitted 
Sql :: how to check port number for postgresql 
Sql :: mysql command line xampp ubuntu 
Sql :: query to find table size in oracle 12c 
Sql :: how to install psql in ubuntu 
Sql :: mysql show table column comments sql 
Sql :: mysql get longest string in column 
Sql :: show indexes in mql 
Sql :: oracle find text in functions 
Sql :: change column names mssql 
Sql :: mysql add days to date 
Sql :: oracle sql log to console 
Sql :: how to check when a stored procedure was last modified in sql server 
Sql :: oracle drop column 
Sql :: postgresql drop primary key constraint 
Sql :: netstat -tln mysql 
Sql :: install mysql workbench ubuntu 20.04 terminal 
Sql :: oracle extract minute from date 
Sql :: how to delete columns in sql 
Sql :: oracle list invalid password ORA-01017 
Sql :: postgres convert exisiting column to text 
Sql :: sql command to find foreign key references 
Sql :: postgresql show current database 
Sql :: sql copy table 
Sql :: How to disable foreign key checks ? 
ADD CONTENT
Topic
Content
Source link
Name
7+4 =