Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
For Beginners
Best Way to Learn SQL
SQL Primer
Flashcards
Guides
150+ SQL Practice Exercises
100+ SQL Interview Questions
GROUP BY and Aggregate Functions Guide
SQL JOINs Guide
Window Functions Guide
Numeric Functions Guide
String Functions Guide
Common Table Expressions
Log in
Create free account
fullName
User profile menu open
Open user profile menu
fullName
Dashboard
My Profile
Payment & Billing
Log out
MENU
CLOSE
Courses
Pricing
For Students
Articles
Cookbook
Cheat Sheets
Best Way to Learn SQL
SQL Primer
Flashcards
150+ SQL Practice Exercises
100+ SQL Interview Questions
GROUP BY and Aggregate Functions Guide
SQL JOINs Guide
Window Functions Guide
Numeric Functions Guide
String Functions Guide
Common Table Expressions
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
7 Jan 2014
Agnieszka Kozubek-Krycuń
MySQL's group_concat Equivalents in PostgreSQL, Oracle, DB2, HSQLDB, and SQLite
The GROUP_CONCAT() function in MySQL MySQL has a very handy function which concatenates strings from a group into one string. For example, let's take a look at the children table with data about parents' and children's names. if (typeof VertabeloEmbededObject === 'undefined') {var VertabeloEmbededObject = "loading";var s=document.createElement("script");s.setAttribute("type","text/javascript");s.setAttribute("src", "https://my.vertabelo.com/js/public-model/v1/api.js");(document.getElementsByTagName("head")[0] || document.documentElement ).appendChild(s);} parent_name child_name John Tom Michael Sylvie John Anna Michael Sophie To get the names of children of each person as a comma-separated string, you use the GROUP_CONCAT() function as follows:
Read more
1 Jan 0001
LearnSQL.com Team
New Monthly SQL Practice for October 2024!
Ready for a new basic-level SQL challenge? This time, you will help Chef Adrian, the owner of an up-and-coming restaurant, Savory Seasons. Get ready to dive into the world of SQL queries as you help Chef Adrian analyze the performance of his kitchen and create the best experience for his guests! Welcome to the October SQL Practice course! In our October 2024 SQL Practice, you will meet Chef Adrian. He owns an up-and-coming restaurant, Savory Seasons, and seeks help in gaining deeper insights from his database.
Read more
««
«
1
2
3
84
85
»
»»