When I first stepped into the world of data, I was a college student captivated by the simplicity of SQL. The language seemed straightforward, almost like plain English. With commands like SELECT…

Colkgirl shines a spotlight on women in tech, diversity, and inclusion initiatives, providing a platform for celebrating the contributions and achievements of women in the technology industry. Developers engaging with Colkgirl's content can expect to discover inspiring stories, insightful interviews, and  articles that highlight the experiences and perspectives of women in tech. 

Code Like A Girl

Understanding the differences between GROUP BY and PARTITION BY clauses in SQL is crucial for efficient data analysis. GROUP BY is used to summarize data by grouping rows that have the same values in specified columns, while PARTITION BY is used for detailed calculations within specific partitions. GROUP BY can reduce the number of rows by summarizing data, whereas PARTITION BY adds additional information without reducing rows. Both clauses support aggregate functions, but PARTITION BY also supports ranking and time-series functions.

SQL Essentials: GROUP BY vs. PARTITION BY explained

How about having a 1-to-1 meeting with each?

Fine, but….still don’t see the differences

Article is behind a paywall which sucks. No one wants to sign up for another account. Geesh.

Dailey.dev became a platform where users can generate ChatGPT content, and forcing you to pay to read it, unfortunately.

Articleis behind some sort of paywall, I don’t another account signup.