Advertisement
wzline

Distribution empty orders on time

Feb 21st, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  1. select
  2.     DATE_FORMAT(o.DATE_INSERT,'%H:00') as TIME,
  3.     COUNT(*) as CNT
  4. from
  5.    b_sale_order o
  6.    left join b_sale_basket b on b.ORDER_ID = o.ID
  7. where 1=1
  8.    and b.ID is NULL
  9.  
  10. group by TIME
  11. order by TIME ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement