Advertisement
TDCustmerSupportJP

Untitled

Jul 12th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.26 KB | None | 0 0
  1. SELECT member_id, TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST') AS d, SUM(price * amount) AS sales
  2. FROM sales_slip
  3. WHERE TD_TIME_RANGE(time, '2006-01-01', '2007-01-01','JST')
  4. GROUP BY TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST'), member_id
  5. ORDER BY member_id, sales DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement