Traditional Culture Encyclopedia - The 24 Solar Terms - How does sql server group and count all data by quarter?
How does sql server group and count all data by quarter?
Group by month
The difference between quarterly grouping and monthly grouping should be the difference of time period!
Choice? Case? whenmonth(date)= 1? Or? Month (date)? =2?
Or? Month (date) =3? then what The first quarter?
whenmonth(date)=4? Or? Month (date)? =5?
Or? Month (date) =6? then what Q2?
whenmonth(date)=7? Or? Month (date)? =8?
Or? Month (date) =9? then what The third quarter?
whenmonth(date)= 10? Or? Month (date)? = 1 1?
Or? Month (date) = 12? then what The fourth quarter?
Or what? ''? End? , total (quantity)
From where? Table?
Group? pass by
Case? whenmonth(date)= 1? Or? Month (date)? =2?
Or? Month (date) =3? then what The first quarter?
whenmonth(date)=4? Or? Month (date)? =5?
Or? Month (date) =6? then what Q2?
whenmonth(date)=7? Or? Month (date)? =8?
Or? Month (date) =9? then what The third quarter?
whenmonth(date)= 10? Or? Month (date)? = 1 1?
Or? Month (date) = 12? then what The fourth quarter?
Or what? ''? end
- Related articles
- What is the first seven, and how does the first seven pay homage to relatives?
- Small class solar terms in winter
- Jiaxing freehand brushwork on the tip of the tongue in Jiangnan
- In what season is Xanthium sibiricum abundant?
- Causes of high idle speed when Nissan Sylphy starts.
- Hornet 600, come on, vomit.
- When does Xi 'an usually get cold?
- Pig prices rose 10.24%. Cold and New Year's Eve are linked. Will the pig price go up or down after the year? There's news
- What is Binyang in Guangxi like?
- What is the reason why the car won't catch fire at MINUS 20 degrees?