SQL and Bible Studies:- Books in each Genre

Background The Bible is a collection of books. One can categorize the books in so many different ways. In this post, we will use someone else work. He has categorized bible books into genres.   SQL The work avails a couple of database platforms. In this post, we will provide working samples for Transact SQL … Continue reading SQL and Bible Studies:- Books in each Genre

MySQL:- Group_Concat Function

Background When viewing data an aggregated view can sometimes be easier to read.   Data Model ER-Diagram Images   Data Presentation Images Detail   Summary   GROUP_CONCAT MySQL offers an option for aggregating data through its GROUP_CONCAT function. Code SQL Source Code Control GitHub Gist DanielAdeniji/MySQLGroupConcatFunction.sql Link