Advertisement
Azerpsen

Untitled

Jan 25th, 2023
257
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH horairesP(na, id, heure_passage) AS (
  2.     SELECT passage.nomArret AS na, passage.idLigne AS id, heureDeb AS heure_passage
  3.     FROM passage
  4.  
  5.     UNION ALL
  6.  
  7.     SELECT na, id , (heure_passage + frequence)
  8.     FROM horairesP , ligne l , passage p
  9.     WHERE na = p.nomArret
  10.     AND id = l.idligne
  11.     AND heure_passage + L.frequence < p.heureDeb + l.duree
  12. )
  13. SELECT *
  14. FROM horairesP;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement