,,,
1.
1.1
, , , , , , , .
:
1. , , . ;
2. , . , , ;
3. , . , .
, , .
, . , .
:
;
;
.
1.3
1.4
2 :
: (, , )
-: - - .
:
1. :
( -)- (..., , ..), ;
( - ) , ( , , ..);
( - )- , ( , , ..);
2. :
( - )- (, , ..);
( ) , (, , ..);
( )- , , ( , );
( - )- , ( , , ..);
( )- , : , , , , , ;
( ) , : , , ..
, , , .
, : --.
--. , . : ().
-- , . () . , , , .
( ) , . , .
, . , .
:
1) , .
( ).
2) , .. , () .
: , , , , . .
3) , .
. . , , , .
:
1. - , . :
- .
2 .
, , .
2. :
, .
3. :
. , , .
4. :
.
5. :
- , .
6. :
.
7. :
● , .
8. :
● . .
SQL.
1.
SELECT DISTINCTROW [ ]. , . , . , ., ., [ ]. , [ ]. , [ ]. AS 1, [ ]. AS 2, Sum ([ ]. +[ ]. ) AS
FROM [ ], ( INNER JOIN ( INNER JOIN ON . = . ) ON . = ) INNER JOIN ([ ] INNER JOIN [ ] ON [ ]. = [ ].) ON . = [ ].
GROUP BY [ ]. , . , . , . , . , [ ]. , [ ]. , [ ]. , [ ].
HAVING ((([ ]. ) = [Forms] ! [] ! []));
2.
SELECT .*, . , .
FROM INNER JOIN ( INNER JOIN ON . = . ) ON . = . ;
3.
SELECT . , . , . , . , [ ]. , [ ]. , [ ]. , [ ].
FROM [ ] INNER JOIN (( INNER JOIN ( INNER JOIN ON . = .) ON . = . ) INNER JOIN ([ ] INNER JOIN [ ] ON [ ]. = [ ].) ON . = [ ]. ) ON [ ]. = [ ]. ;
4.
SELECT . , . , . , . INTO [ ]
FROM INNER JOIN ON . =.
WHERE (((Date())= ))
ORDER BY . ;
5.
SELECT , , , , "" AS []
FROM
UNION SELECT , , , , ""
FROM ;
6.
INSERT INTO
VALUES ([ :], [ :], [ :], [ :], [ :], [ :], [ :], [ :], [ :]);
7.
DELETE *
FROM
WHERE =[ :];
8.
UPDATE [ ] SET [, %] = [ ]
WHERE (()=[ ]);
9.
SELECT , , SUM( + ) AS [ ]
FROM
GROUP BY , ;
10.
TRANSFORM SUM([ ].) AS [Sum- ]
SELECT [ ].
FROM [ ]
GROUP BY [ ].
PIVOT [ ]. ;
. , . , SQL, . .
:
1. - ;
2. - . ;
3. - , ;
4. - , .
Microsoft Access 2003 .
Avtoservice.mdb. , , , ( ).
, , .
, , , .
, , . , .
:
. .
, , .
. , , . ( ), , , .
3.
, .
:
:
:
1. .. , .. , .. , 2006 .
2. .. Access 2003 , 2004.
3. . , . SQL- . SQL , 2003 .
4. .. , ., 2008 .
1. 1.1 , ,
Copyright (c) 2024 Stud-Baza.ru , , , .