Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // 当月培训次数
- db.query("SELECT SUM(times) AS count FROM county.train WHERE date_trunc('month', report_date) = date_trunc('month', NOW())", []),
- // 累计培训次数
- db.query("SELECT SUM(times) AS count FROM county.train", []),
- // 当月三品一标数量
- db.query("SELECT COUNT(1) FROM county.marks WHERE date_trunc('month', report_date) = date_trunc('month', NOW())", []),
- // 累计三品一标数量
- db.query("SELECT COUNT(1) FROM county.marks"),
- // 当月商标数量
- db.query("SELECT COUNT(1) FROM county.brands WHERE date_trunc('month', report_date) = date_trunc('month', NOW())"),
- // 累计商标数量
- db.query("SELECT COUNT(1) FROM county.brands")
Add Comment
Please, Sign In to add comment