SELECT
[ALL | DISTINCT]
[TOP _ [PERCENT]]*
FROM ___
[[INTO _]
| [TO FILE _ [ADDITIVE]
| TO PRINTER [PROMPT] | TO SCREEN]]*
[NOCONSOLE]*
[WHERE ____]
[GROUP BY __]
[HAVING __]
[UNION [ALL] SELECT]
[ORDER BY __]
ALL | DISTINCT - ( )| ; , ;
TOP _ [PERCENT]* - ; ( ) ; - .. ORDER BY;
-
_ [AS ]
- - ; - . , () ()
[ .] _
(.. ) ; AS - .
FROM __
, "" ,
[[INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN *
[_!] _ [ ]
[ON _]
, ( - ) , _!_. , SELECT (, , .. ) / ; () , ;
( , ) - .. . , (, , ) - FoxPro (. ), . , (), , .
|
|
SQL WHERE UNION. FoxPro ( ) .
(INNER JOIN) , ; , (LEFT [OUTER] JOIN) , JOIN, (RIGHT [OUTER] JOIN) - , JOIN, (FULL [OUTER] JOIN) - , .
INTO _| [TO FILE _ [ADDITIVE] | TO PRINTER [PROMPT] | TO SCREEN]]*
, (BROWSE-) . , ( INTO ARRAY _), " ", - ( INTO CURSOR _), (.. DBF- - INTO DBF | TABLE _ [DATABASE _ [NAME __]]), ASCII- ( TO FILE _, ADDITIVE ), ( TO PRINTER, PROMPT ), ( TO SCREEN). NOCONSOLE ""-
WHERE , ( , ). , (. ) . , (, AND) .
GROUP BY __
( ) , . , . , , ; , - :
- COUNT() - , NULL;
- COUNT(*) - ;
- MIN() - ;
- MAX() - ;
- SUM(_) - ;
- AVG(_), - ;
. GROUP BY - ( , )
|
|
HAVING __
( ) WHERE, , , , . GROUP BY. . , . - WHERE.
[UNION [ALL] SELECT] ( , .. ) ; . , FoxPro , , .. . , UNION - ALL (), .
,
- UNION ;
- UNION ORDER BY SELECT, ( ) ; -.
ORDER BY __ [ASC|DESC]
GROUP BY, , , . , - (ASC - ), (DESC).
CREATE SQL VIEW [_ ] [REMOTE]
[CONNECTION ____ [SHARE]
| CONNECTION ___]
[AS SELECT]
REMOTE , , FoxPro. - CONNECTION ___, - CONNECTION ____. SHARE , . CREATE CONNECTION? ( . ).
AS _SELECT
.
FoxPro
1) , FoxPro - ? .
2) ; c
- , , ;
- .
.
, , , , - , ; "" .
CREATE CURSOR _
(___)
(_ _ [(_ [, e])
[NULL | NOT NULL]
[CHECK __
[ERROR ____]]
[DEFAULT __]
[UNIQUE]
. CREATE TABLE.
|
|
SQL, , FoxPro.
, , , ; , SQL . , - " " - , ( , .)
, , .
SQL
BEGIN TRANSACTION
END TRANSACTION
"", ..
ROLLBACK
FoxPro 5 . , , , .
- , (, , ALTER TABLE CREATE TABLE) - . .
.
.
, .
.
:
- ;
- ;
- (, )
-
-
-
-
- ;
:
- ;
- ;
- - [0,1] - , ;
-
-
:
- - ;
- - ;
- - ()
- ( );
- ( )
- , ;
- ( )
.
1) , , :
- , 1.01.1990;
- , 10000 100000 , ;
- , 1.01.1998 - .
1) , , , :
- ;
-
1) " "
2) , , , , , , .
|
|
3) ,
- ,
- ,
- ( - 0101 - '', 0903 - ' ' .),
- -,
- (, . , , ),
-
- .
, ,
- ?
- ?
- ( ) , ?
.
, . ( , ). . , , . , , . .
. , .
( :)
-
- ,
- ,
- ,
- ,
-
,
( :)
- (, )
- ( - , )
- () , ,
- ()
( :)
-
- ,
- ,
- ,
- ,
,
( :)
- (, )
- ( - , )
- -, -
- ,
( :)
-
-
-
-
-
( :)
- ,
- (, , , ),
- ()
- ,
- , ,
( :)
-
- ,
( :)
- ()
- () ,