ВУЗ: Не указан
Категория: Не указан
Дисциплина: Не указана
Добавлен: 13.06.2021
Просмотров: 3413
Скачиваний: 2
626
,
–
.
,
]
,
, –
.
AS
(
.
).
WHERE
,
,
(
. 19.10).
1 9 . 1 0 .
AND
(
)
Imp
Or
Or)
Eqv
Not
r
Or)
,
: LIKE –
; BETWEEN...AND –
; IN –
; IS –
Null
).
"
"
,
.
"
"
,
.
19.74.
,
1.1.79.
,
1212
1213
1.1.79.
,
,
.
,
,
,
1.1.79.
SQL
:
Avg –
,
;
Count –
;
Min, Max –
627
;
StDev, StDevPs -
;
Sum –
;
Var, VarPs –
.
GROUP BY.
HAVING
.
19.75.
SELECT
, vg(
) AS
FROM
GROUP BY [
]
SELECT [
], vg(
) AS
FROM
GROUP BY [
]
,
–
.
19.76.
SELECT
, Avg(
) AS
FROM
GROUP BY [
] HAVING vg(
) > 4.5
SELECT [
], Avg(
) AS
FROM
GROUP BY [
] HAVING
vg(
) < 4
,
,
4.5.
,
4.
SELECT
SELECT, SELECT...INTO,
INSERT...INTO, DELETE
UPDATE.
,
.
SELECT
WHERE HAVING.
:
(ANY | ALL | SOME) (
);
[NOT] IN (
);
[NOT] EXISTS (
).
–
.
:
ANY –
(
).
ALL –
(
).
SOME –
(
).
19.77.
SELECT* FROM
WHERE [
] > ANY
(SELECT [
] FROM
WHERE
.[
]="123124")
,
(
)
123124.
–
,
,
.
628
19.78.
SELECT * FROM
WHERE [
] IN
(SELECT [
] FROM
WHERE [
] > =4)
SELECT * FROM
WHERE [
] NOT IN
(SELECT [
] FROM
)
,
4
.
,
.
–
SELECT,
,
EXISTS (
NOT)
,
.
19.79.
SELECT* FROM
WHERE EXISTS
(SELECT * FROM
WHERE
.[
]=
.[
])
,
.
"
(
)
VBA
:
Microsoft Office
(
)
:
dBASE
QBE
SQL
VBA (Visual Basic for Applications)
1.
?
629
2.
?
3.
?
4.
?
5.
?
6.
?
7.
?
8.
?
9.
Microsoft Office.
10.
Microsoft Office.
11.
Microsoft Office.
12.
Excel 5.0?
13.
Word 6.0?
14.
Excel 5.0?
15.
?
16.
Word 6.0?
17.
Excel 5.0?
18.
"
"
?
19.
"
"
Word 6.0?
20.
"
"
Excel 5.0?
21.
,
.
22.
?
23.
?
24.
?
25.
Word 6.0?
26.
Excel 5.0?
27.
Word 6.0?
28.
Excel 5.0?
29.
Excel 5.0?
30.
VBA.
31.
VBA,
.
32.
,
,
VBA.
33.
,
?
34.
VBA.
35.
VBA.
36.
VBA.
37.
VBA?
38.
VBA.
39.
?
40.
?
41.
VBA?
42.
.
43.
?
44.
?
45.
.
46.
(
)?
47.
?
48.
.
49.
.
50.
.
51.
dBASE-
?
52.
QBE.
53.
SQL?
54.
SQL.
55.
SELECT?
56.
?
630
57.
?
58.
?
?
1.
.,
.
. – 2-
.,
. - .:
, 1995.
2.
.
Microsoft Office 4 (
"
!") /
.
. - .:
, 1996.
3.
.
Visual Basic
Microsoft Office:
.
. - .:
, 1995.
4.
.
Visual Basic for Applications
/
.
. - .:
, 1996.
ABM
AOH
–
–
-
–
–
–
–
–
–
–
–
-
–
–
–
–
–
–
– GFLOPS
–
-
–
-
–
-
-
– KOPS
-
-
-
-
–
-
-
– MIPS
-
-
(
)
(
)
-
(
)
(
)
-
-
-
-
-