(a) , ;
SELECT __.
FROM __ INNER JOIN ON __. = .
WHERE (((__._)="") AND ((._)=""));
b) , -
, ;
SELECT __._
FROM __ INNER JOIN _ ON __. = _.
WHERE (((_._)=1));
c) , -
;
SELECT __., __._
FROM __ INNER JOIN ON __. = .
WHERE (((__._)>#5/11/2013# And (__._)<#5/20/2013#) AND ((._)=28));
d)
( -
);
SELECT Sum(__._) AS [Sum-_], __.
FROM __
GROUP BY __., __._
HAVING (((__._)=""))
ORDER BY Sum(__._) DESC;
e) ,
;
1) SELECT DISTINCT __._, __.
FROM __
GROUP BY __._, __.;
2) SELECT Count([ (e)]._) AS [Count-_], [ (e)].
FROM [ (e)]
GROUP BY [ (e)].
HAVING (((Count([ (e)]._))>1));
f)
.
1) SELECT _._, Sum(__._) AS [Sum-_1]
FROM __ INNER JOIN _ ON __. = _.
GROUP BY _._
ORDER BY _._;
2) SELECT _._, Count(__.) AS [Count-]
FROM __ INNER JOIN _ ON __. = _.
|
|
GROUP BY _._;
.
1. , .
, , , .
1 , , . () .
2. .
, . .
3. , . , .
. , , , .
. , , , .
. , , , , - .
4. . .
: R, , , .
:
. ( )
. ( )
... . ( - ... )
5. , 2. , .
2 - 1 , , .
1:
( ..., , , , , , , )
, : , ... .
, 3 ..., .
:
( .., )
( , )
( , )
6. , 3.
|
|
3 2 .
.
7. HAVING.
:
SELECT Sum(__._) AS [Sum-_], __.
FROM __
GROUP BY __., __._
HAVING (((__._)=""))
8. , ( ) , .
. , _ _ _ , .
. , . , , .
.
( ..., , , , )
( .., )
( , , )
d)
( -
);
SELECT __._, Count(__.) AS [ ], Max(__._) AS [ ]
FROM __
GROUP BY __._;
e) ,
;
f)
.
SELECT ._, Count(.) AS [ ]
FROM
GROUP BY ._;