Composition d'une requête
Accueil Histoire > Bases de Données > Armements Malouins >

COMPOSER VOTRE REQUÊTE SUR LA BASE des Armements Malouins

CODE SQL :




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