Write query to print a comma separated list based on other columns |
Question :- Write a query to print a comma separated list of student names in a grade.
The GROUP_CONCAT() function in MySQL is used to concatenate data from multiple rows into one field. This is an aggregate (GROUP BY) function which returns a String value, if the group contains at least one non-NULL value. Otherwise, it returns NULL
If you want to be better in Analytics, then do follow the below Playlist:-
Excel Playlist:- • What is MS Excel | Introduction To Ex...
SQL Playlist:- • Introduction to SQL | SQL For Beginne...
Google Data Studio playlist:- • Introduction to Looker|Introduction t...
You can follow us on the below social media handles:-
Blog: - https://thedatamillennials.blogspot.com/
Facebook:- / the-data-millennials-596575371027542
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a031b3
Twitter: - / datamillennials