3
: ACCESS ANSI SQL.
, . , .
ACCESS : QBE- (Query By Example - ) SQL- (Structured Query Language- ), SQL.
1. primer_lab3_sp.mdb .
2. (2 3 Variants.doc)
:
1. 6 Access.
2. SQL (Select, From, Where, Group By, Having, Order By, Into, As). sql.rtf.
1. ,, Citroen 2004 01.05.98. : , , , , , , . , , .
QBE-.
. , (. .1).
. . . . , . .
. . , ( .2).
;
.
.
.
, , ,. - . , , , - , . a. . 2004 , 01.05.98 . Citroen. :
|
|
Citroen
>=#01.10.04# And <#01.11.04#>01.05.98
<ENTER>, ACCESS . , . . . .39.
c . Access , (. 10 4).
, , ACCESS SQL-. SQL SQL. SQL.(.115)
SQL- SQL. QBE-.
SQL- , SQL-. , .
1, ANSI SQL, :
SELECT , , , [ ]
FROM INNERJOIN
ON . _= ._
WHERE ((="Citroen") AND (=-"") AND ([ ]>5/01 /98)
AND .[ ]=.[ ])
ORDER BY SELECT , , , ,
FROM INNER JOIN ( INNER JOIN ON . = . ) ON . = .
WHERE (( ="") AND ( >=#10/1/2004# A ND <#11/1/2004#) AND ( =""))
ORDER BY
: , [] .
, . ACCESS SQL: Sum, Avg, Min, Max, Count .
2. , , , , . : , 43 , : , , , . .
. Sum Count, Max, Min Avg. , , , ., { , , , _ } : (. .126).
|
|
:
ANSI SQL:
SELECT ([ ]) AS __,
vg([ ]) AS __,
[N ]
FROM INNER JOIN ON .[N ] = .[N ]
SELECT ., Count (.[ ]) AS [ ],
Max (.) AS [ ],
Min (.) AS [ ],
Avg (.) AS [ ]
FROM INNER JOIN ON . = .
GROUP BY .;
GROUP BY .[N ];
3: -. : , . .
, . : _, , _, _. : -. . .
, - ( 8).
. 15.9.
ANSI SQL:
SELECT ., Count( .[ ] ) AS [ ]
FROM INNER JOIN ON . = .
GROUP BY .
HAVING .="";
- , (, - ). , , . QBE-. , . . ( ) ACCESS , , . .
4: , :
= *
, , , :
[]*[]
, , Is Null (. 10). .
( 11), .
,
ANSI SQL :
|
|
UPDATE SET . = []*[]
WHERE (((.) Is Null));