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

SQL Server Aggregate Functions | SQL Beginner Guide

SQL Server offers several built-in functions. SQL Aggregate functions are among the ones most widely used in reporting & data joining scenarios. Following are few SQL Aggregate functions we will discuss today COUNT ()                  returns the total number of values in a given columnSUM ()      … Continue reading SQL Server Aggregate Functions | SQL Beginner Guide