How Grouping Works in SQL

One of our subscribers reached us and asked How Grouping works in SQL ?  So today , this is what we are going to do . We will discuss in detail about grouping in SQL and how it actually works behind the scenes. Also , this is our first post in Questions category and we will … Continue reading How Grouping Works in SQL

MS SQL Group By Clause | SQL Beginner Guide

MS SQL Group By Clause in SQL is used with aggregate functions to group data based on columns. Before , we jump to details of the Group By clause let's try to understand about grouping. SQL is based on set-theory and whenever you're composing a query you treat a table as a whole & not … Continue reading MS SQL Group By Clause | SQL Beginner Guide