SQL FOXPRO 2.0
FoxPro SQL. SQL FoxPro.
CREATE DBF <DBF-> (< >< > [(<>[,< >]) [,< >...]])
: DBF- . , ( C, N, D, M, F, L), . (D), (L) (M).
. KADR.DBF
CREATE DBF kadr (FAM C(15), TAB N(3), DTR D, POL C(1), SEM C(1), DET N(1),;
PODR C(15), SZAR N(9), PER M)
INSERT INTO < > [(< 1> [,< 2>...] VALUES (<1>[,< 2>...])
.
INSERT INTO kadr (fam, tab, szar) VALUES ('', 350, 800000)
SELECT < >
FROM < ()>INTO < ()>
WHERE < >
GROUP BY < , >
HAVING < >
ORDER BY < >
SELECT
SELECT [DISTINCT] [< >. ]< > [AS < > ]
FROM <>[< > ] [,< > [< > ]...]
, , . , , . , , , AS. , .
DISTINCT - .
INTO
ARRAY < > -
CURSOR < > -
DBF/TABLE < > -
- , .
, .
TO FILE < > ADDITIVE / TO PRINTER - . ADDITIVE, .
GROUP BY < > - .
HAVING < > - .
ORDER BY < > [ASC/DESC] - . (ASC) (DESC).
.
|
|
COUNT() .
SUM() - .
AVG() .
MAX() .
MIN() .
1.
kadr(fam, tab, dtr, pol, sem, det, podr, szar, per)
brig1(nar, tab, vir)
brig2(nar, tab, vir)
: fam-, tab- , pol-, sem- , det- , podr-, szar-., per- , nar- , vir-
2.
3. SQL
1. kadr.dbf
SELECT * FROM kadr
2. , SZAR ( ).
SELECT MIN(szar), MAX(szar), AVG(szar) FROM kadr
3. , 4000 7000 .
SELECT fam FROM kadr WHERE szar BETWEEN 4000 AND 7000
4. ( PODR) .
SELECT DISTINCT podr FROM kadr
DISTINCT .
5.
6.
SELECT s.fam, t.vir FROM kadr s, brig1 t WHERE s.tab=t.tab
s t.
7. () , - 50% .
SELECT fam, DAY(dtr), '', YEAR(DATE())-YEAR(dtr), '',;
'', 0.5*szar FROM kadr WHERE MONTH(dtr)=MONTH(DATE())
8. FAM TAB, POL ( ) FAM ( ) FAMTAB.DBF
SELECT fam, tab FROM kadr ORDER BY pol, fam INTO TABL famtab
BROWSE
9. BRIG1 BRIG2, .
SELECT kadr, tab, brig1.vir, brig2.vir, brig1.vir+brig2.vir;;
FROM kadr, brig1, brig3;;
WHERE kadr.tab=brig1.tab AND kadr.tab=brig2.tab
10. , (). - PER.
SELECT fam FROM kadr WHERE per LIKE "%%"
11. 1. .
SELECT tab, SUM(vir) FROM brig1 GROUP BY tab ORDER BY tab
12. , ( ). , .
SELECT podr, COUNT(*), SUM(szar) FROM kadr GROUP BY podr HAVING COUNT(*)>5
, :
S (N_P, FAM, SOST, Gorod) -
P (N_D, Name, Color, Ves, Gorod) -
SP(N_P, N_D, Kol) -
1. S, P, SP
2. , 20
|
|
3.
4. , .
5. , 2
.
6. , , ,
7. , , , , S2. ().
8. , 3 EXISTS.
9. SP
10.
11. SOST .