1 1 2014-01-01
2 2 2014-01-01
3 0, 2014-01-01
4 0, 2014-01-03
May 2, 2014-01-04
June 1, 2014-01-04
July 1 2014-01-06
8 the 2014-01-06
2September 1, 2014-01-07
Now to get the following record in the 2014-01-01 to 2014-01-01 and need according to the type of value respectively statistics
The date the count type0 type1 type2
The 2014-1-1 3 1 1 1
The 2014-1-2 0 0 0 0
The 2014-1-3 1 1 0 0
The 2014-1-4 2 0 1 1
The 2014-1-5 0 0 0 0
The 2014-1-6 2 0 1 1
The 2014-1-7 1 1 0 0
SQL table access time every day, no record data of the day, if the list of 0
Don't know the great god can help me to solve this problem, I appreciate,
CodePudding user response:
Top 1 ~ please teach the great god, thank you very much!