Advertisement
TDCustmerSupportJP

Untitled

Jul 12th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.23 KB | None | 0 0
  1. SELECT goods_id, COUNT(1) AS pv, COUNT(DISTINCT member_id) AS uu, APPROX_DISTINCT(member_id) AS approx_uu
  2. FROM sales_slip
  3. WHERE TD_TIME_RANGE(time, '2006-05-01', '2006-06-01','JST')
  4. GROUP BY goods_id
  5. ORDER BY uu DESC
  6. LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement