Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
group_concat MYSQL new line
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
SELECT Name, GROUP_CONCAT(city SEPARATOR '\n') AS city, nb FROM (SELECT 'A' AS Name, 'Agra' AS city, 101 AS nb UNION ALL SELECT 'B' AS Name, 'Delhi' AS city, 102 AS nb UNION ALL SELECT 'A' AS Name, 'Allahabad' AS city, 101 AS nb) AS a GROUP BY Name, nb;
absolute service time: 0,33 sec
edit mode
|
history
Name
city
nb
1
A
Agra Allahabad
101
2
B
Delhi
102