5
: SQL.
: SQL.
: ` Windows.
:
, . ` , .
, . , .
- , , , . . ³ .
ճ :
18 . , SK.mdb.
.1.1. , .
: 1. , 1 ( ..) 1.
SQL: SELECT ., ., .ʳ, ., .[ ], .
FROM INNER JOIN ( INNER JOIN ON . = .) ON . = .
WHERE (((.)=1));
: 5. (, ) ( ). . , , , 3.
SQL: SELECT ., .,
Sum([ʳ]*[]) AS
FROM INNER JOIN ON . =
.
GROUP BY ., .
HAVING (((.)>3))
ORDER BY Sum([ʳ]*[]);
1.2.5.
: 18. ( , )
SQL: DELETE .
FROM
WHERE (((.) Not In (SELECT FROM )));
: 16. , 1 .
SQL: SELECT ., Count(.) AS [Count-]
FROM
GROUP BY .
HAVING (((.) In (SELECT FROM GROUP BY
HAVING COUNT()>1)));
:
