• Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

Comments (1)

1 Yonghang commented Permalink

optimization:

 
use CTE to generate the same week day in the whole month. So this problem can be resolved with rownumber() + max() or count(). Much easier.

Add a Comment Add a Comment