Skip to content

Latest commit

聽

History

History
6 lines (5 loc) 路 715 Bytes

2020-12-01.md

File metadata and controls

6 lines (5 loc) 路 715 Bytes
Raw
publish_date
2020-12-01
  • Worked through more postgres tutorials. Completed Section 5. Set Operations unions, interesets and except clauses.
  • Got pretty confused working through Section 6. Grouping sets, Cube, and Rollup , but this youtube vide explained it well and I finally grocked it. I just dont understand when you want to have grouped data like that. CUBE and ROLLUP functions are interesting shortcuts to producing variations of grouped data from your table, but simarly, i just dont know why you would want to work with data like that. seems to makes more sense for it to be seperate queries to me.