Advertisement
Guest User

Untitled

a guest
Oct 24th, 2014
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. datediff(hour, o.vytvorena, o.potvrzena) as hodin
  2. from zbozi z
  3. join polozka p on p.zid = z.zid
  4. join objednavka o on o.oid = p.oid
  5. where o.potvrzena IS NOT NULL
  6. group by z.zid, o.vytvorena, o.potvrzena, z.nazev, o.oid
  7. having datediff(hour, o.vytvorena, o.potvrzena) = (
  8.  
  9. select MIN(hodin.hodin2) from (
  10. select datediff(hour, ob.vytvorena, ob.potvrzena) as hodin2
  11. from zbozi zb
  12. join polozka po on po.zid=zb.zid
  13. join objednavka ob on ob.oid = po.oid
  14. where ob.potvrzena IS NOT NULL and zb.zid = z.zid
  15. ) hodin
  16. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement