パート単位でグループ化
SELECT BUYDATE FROM PC
| BUYDATE |
|---|
| 1900-01-01 00:00:00.000 |
| NULL |
| 2000-03-15 14:10:05.000 |
| 1995-06-13 00:00:00.000 |
| 2001-01-11 18:20:15.000 |
| 2000-03-12 00:00:00.000 |
| 2000-08-01 00:00:00.000 |
| 1999-12-16 13:50:52.000 |
| 2001-01-11 01:03:18.000 |
SELECTYEAR(BUYDATE) AS [YEAR],COUNT(*) AS [CNT]FROM PCGROUP BY YEAR(BUYDATE)
| YEAR | CNT |
|---|---|
| NULL | 1 |
| 1900 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 2 |