Guest User

Untitled

a guest
Jan 19th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. SELECT (CASE
  2. WHEN pourcenthour < pourcentcycle AND pourcenthour < pourcentmonth THEN pourcenthour
  3. WHEN pourcentcycle < pourcenthour AND pourcentcycle < pourcentmonth THEN pourcentcycle
  4. WHEN pourcentmonth < pourcenthour AND pourcentmonth < pourcentcycle THEN pourcentmonth
  5. ELSE 100
  6. END) AS pourcent,
  7. ata,
  8. immatriculation
  9. FROM part_log
  10. WHERE removed = "false" AND immatriculation =? AND ata=?
  11. ORDER BY pourcent DESC LIMIT 1
  12.  
  13. SELECT IFNULL((CASE WHEN ... ELSE 100 END),100) AS pourcent, ...
  14.  
  15. SELECT IFNULL(SELECT (CASE WHEN ... ELSE 100 END) ,100) AS pourcent
Add Comment
Please, Sign In to add comment