Sql Group By Quarter Examples

We use datepart method to get quarter part of a date. We will do some examples on library database at below.

Example 1:

List the number of books read grouped by date quarter

Select Year(takendate) as Year, datepart(qq,takendate) as Quarter,count(*) as Count 
from borrows 
group by Year(takendate),datepart(qq,takendate)

Select Year(takendate) as Year, datepart(qq,takendate) as Quarter,count(*) as Count

from borrows

group by Year(takendate),datepart(qq,takendate)

Result Of Query

Example 1:

List the student count gruped by date quarter

Select Year(birthdate) as Year, datepart(qq,birthdate) as Quarter,count(*) as Count 
from students 
group by Year(birthdate),datepart(qq,birthdate)

Select Year(birthdate) as Year, datepart(qq,birthdate) as Quarter,count(*) as Count

from students

group by Year(birthdate),datepart(qq,birthdate)

Result Of Query