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

Posted on 2009-04-15
Medium Priority
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 :-)
Question by:pcelba
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24152541
oracle: check out for stragg:

sql server: check out for the xml method:
LVL 43

Author Closing Comment

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

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