?
Solved

Does the GROUP_CONCAT() MySQL function have equivalent in MS SQL 200x and possibly PL/SQL?

Posted on 2009-04-15
2
Medium Priority
?
2,308 Views
Last Modified: 2013-12-07
Hi experts, I've been monitoring the following question: http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/Q_24325145.html?cid=1066
and I would like to know what is the equivalent of GROUP_CONCAT in other SQL dialects?

TIA for your answers.

It seems I'll install MySQL because it has many useful features :-)
0
Comment
Question by:pcelba
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24152541
oracle: check out for stragg:
http://www.sqlsnippets.com/en/topic-11591.html

sql server: check out for the xml method:
http://weblogs.sqlteam.com/mladenp/archive/2007/06/01/60220.aspx
0
 
LVL 43

Author Closing Comment

by:pcelba
ID: 31570712
It seems you have large library of solutions. Thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question