|
|
STRUCTURE DE LA BASE navigations_sm2 :
- bateaux(bIDBATEAU, bDATE_CONSTRUCT, bTYPE, bARMATEUR, )
- etapes(eIDETAPE, eIDVOYAGE, eNUMETAPE, eSUITE, ePORTDEP, eDATEDEP, eCHARGEMENT, eNBRE_MORUE, )
- frets(fCHARGEMENT, fOCCURRENCES, fGENRE, )
- ports(pPORT, pOCCURRENCES, pREGION, )
- voyages(vIDVOYAGE, vIDBATEAU, vANNEE_DESARM, vNUMV, vQUART_IMMAT, vQUART_ARM, vTYPE_NAVIGATION, vDESTINATION, vCAPITAINE, vNBRE_HOMME, )
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
|