8. .
SELECT [ ], Sum ([ ]) AS [ ], Avg ([ ]) AS [ ]
FROM
GROUP BY [ ];
7666,67 | ||
12333,33 | ||
7333,33 | ||
23666,67 |
[ ].
, [ ], SUM AVG . , , GROUP BY, , . , , , .
.
9. . .
SELECT [ ], [ %] AS [ ], Sum ([ ]) AS [ ], Avg ([ ]) AS [ ]
FROM ,
WHERE (((.)=[].[ ]))
GROUP BY [ ], [ %];
7666,67 | |||
12333,33 | |||
7333,33 | |||
23666,67 |
10. .
, .
/ SQL
Day -
Month-
Year- .
SELECT Month() AS , Count([ ]) AS [ ], Avg([ ]) AS [ ], Sum([ ]) AS [ ]
FROM
GROUP BY Month();
10_1. 2009 .
, , =1, .
HAVING. , , WHERE . HAVING , , GROUP BY.
|
|
SELECT Month() AS , Count([ ]) AS [ ], Avg([ ]) AS [ ], Sum([ ]) AS [ ]
FROM
GROUP BY Month()
HAVING (Month()=1);
10_2. 2009.
SELECT Month() AS , Sum([ ]) AS [ ], Min([ ]) AS [Min ], Max([ ]) AS [Max ]
FROM
GROUP BY Month()
HAVING (((Month([])) Between 1 And 3));
Min | Max | ||
, - .
ORDER BY . (ASC) (DESC) . , .. ASC . .
11. , , :
SELECT , [ ],
FROM
ORDERBY , [ ] DESC;
05.01.2009 | . | |
05.01.2009 | . | |
05.01.2009 | . | |
10.01.2009 | . | |
02.02.2009 | . | |
02.02.2009 | . | |
02.02.2009 | . | |
02.02.2009 | . | |
02.02.2009 | . | |
02.02.2009 | . | |
01.03.2009 | . | |
04.03.2009 | . |
SQL . , . . , .