Advertisement
Guest User

Knowledge Item Upload

a guest
Jun 25th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. SELECT
  2. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-01-01' AND '2019-01-31' AND Status = 'ENABLED') AS `January 2019`,
  3. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-02-01' AND '2019-02-31' AND Status = 'ENABLED') AS `February 2019`,
  4. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-03-01' AND '2019-03-31' AND Status = 'ENABLED') AS `March 2019`,
  5. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-04-01' AND '2019-04-31' AND Status = 'ENABLED') AS `April 2019`,
  6. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-05-01' AND '2019-05-31' AND Status = 'ENABLED') AS `May 2019`,
  7. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-06-01' AND '2019-06-31' AND Status = 'ENABLED') AS `June 2019`,
  8. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-07-01' AND '2019-07-31' AND Status = 'ENABLED') AS `July 2019`,
  9. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-08-01' AND '2019-08-31' AND Status = 'ENABLED') AS `August 2019`,
  10. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-09-01' AND '2019-09-31' AND Status = 'ENABLED') AS `September 2019`,
  11. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-10-01' AND '2019-10-31' AND Status = 'ENABLED') AS `October 2019`,
  12. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-11-01' AND '2019-11-31' AND Status = 'ENABLED') AS `November 2019`,
  13. (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-12-01' AND '2019-12-31' AND Status = 'ENABLED') AS `December 2019`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement