SHARE
TWEET

Untitled

a guest Jun 18th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top