|
|
STRUCTURE DE LA BASE cabotages :
- activitesbateaux(aNOMBATEAU, aANNEE, aARMEMENT, aACTIVITE, )
- codereg(cREGION, cCODEREGION, )
- escales(eESCALE, eNBDEPART, eNBARRIVEE, eREGION, )
- frets(fFRET, fNOMBRE, fNATURE, fCODEFRET, )
- navigations(nNOMBATEAU, nANNEE, nNUMETAP, nDEPART, nFRET, nARRIVEE, )
- statutsbateaux(sNOMBATEAU, sSTATUT, )
PRINCIPAUX MOTS CLEFS SQL :
- SELECT, DISTINCT, AS, FROM, JOIN, LEFT JOIN, ON
- WHERE, IN, BETWEEN, LIKE, AND, OR, NOT, IS NULL, IS NOT NULL
- ORDER BY, DESC
- SUM(), AVG(), MAX(), COUNT(), COUNT(DISTINCT )
- GROUP BY, HAVING, UNION, SOME, ALL
|