Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
Co-Related sub query
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
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
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
create table #tmp(roleid int,comid varchar) insert into #tmp values(1,'A'),(1,'B'),(2,'C'),(2,'D') select * from #tmp SELECT roleid, comid= STUFF((SELECT ', ' + comid FROM #tmp r where r.roleid=t.roleid FOR XML PATH('')), 1, 2, '') FROM #tmp t GROUP BY roleid SELECT ', ' + comid FROM #tmp r FOR XML PATH('') drop table #tmp
View schema
Execution time: 0,02 sec, rows selected: 10, rows affected: 4, absolute service time: 0,22 sec, absolute service time: 0,22 sec
edit mode
|
history
|
discussion
roleid
comid
1
1
A
2
1
B
3
2
C
4
2
D
roleid
comid
1
1
A, B
2
2
C, D
XML_F52E2B61-18A1-11d1-B105-00805F49916B
1
, A, B, C, D