Guest User

Untitled

a guest
Jan 20th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. // 当月培训次数
  2. db.query("SELECT SUM(times) AS count FROM county.train WHERE date_trunc('month', report_date) = date_trunc('month', NOW())", []),
  3. // 累计培训次数
  4. db.query("SELECT SUM(times) AS count FROM county.train", []),
  5. // 当月三品一标数量
  6. db.query("SELECT COUNT(1) FROM county.marks WHERE date_trunc('month', report_date) = date_trunc('month', NOW())", []),
  7. // 累计三品一标数量
  8. db.query("SELECT COUNT(1) FROM county.marks"),
  9. // 当月商标数量
  10. db.query("SELECT COUNT(1) FROM county.brands WHERE date_trunc('month', report_date) = date_trunc('month', NOW())"),
  11. // 累计商标数量
  12. db.query("SELECT COUNT(1) FROM county.brands")
Add Comment
Please, Sign In to add comment