Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. select
  2. count(date_format(start_date, '%W')) AS "NUMBER OF DAYS",
  3. repeat('*', "NUMBER OF DAYS")
  4. from ABC
  5.  
  6. select
  7. `NUMBER OF DAYS`,
  8. repeat('*', `NUMBER OF DAYS`)
  9. from
  10. (
  11. select
  12. count(date_format(start_date, '%W')) AS `NUMBER OF DAYS`
  13. from ABC
  14. ) as t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement