Sep 18, 2025 路 3 min read 路 Welcome back to my Power BI for Beginners series! 馃殌On Day 4, I explored two very important features in Power BI: Filtering and Group By. These are the building blocks for shaping and summarizing data before turning it into powerful visualizations. L...
Join discussion
Jul 10, 2025 路 2 min read 路 Question: I'm wondering if it's possible to create a custom SQL group by function. For example, I often need to find the most common value within a group. While I can achieve this using CTEs or subqueries, having a custom group by function like the e...
Join discussion
Nov 7, 2024 路 3 min read 路 1. Introduction 鈥淚n SQL, the GROUP BY clause is essential for anyone working with data. Whether you鈥檙e counting customer orders, calculating sales totals, or analyzing data trends, understanding GROUP BY can help you quickly and effectively summarize...
Join discussionMay 7, 2024 路 1 min read 路 The GROUP BY clause in SQL is used to group rows that have the same values in specified columns into summary rows. It is typically used with aggregate functions like SUM, COUNT, AVG, etc., to perform calculations on grouped data. When using GROUP BY,...
Join discussionAug 12, 2023 路 5 min read 路 What is WITHIN GROUP CLAUSE in PostgreSQL? The WITHIN GROUP clause is a special part of SQL that helps you control how data is grouped and processed when you're using ordered-set aggregate functions. The WITHIN GROUP clause is particularly useful whe...
Join discussion
Jul 23, 2023 路 13 min read 路 1. Introduction - Database: MS SQL SERVER We have data from 20 countries on which we are performing the Grouping and Advance SQL functions like Window Functions. For grouping follow - FWGH (From - Where - Group BY - Having) Sequence. 2. Create &...
Join discussion
Mar 3, 2023 路 8 min read 路 Learning SQL is like taking a road trip in an unknown desert. Finding a cool oasis with a shade will describe the moments when you are finally able to write queries with simple SELECT statements. The sandstorms will perfectly describe the moments whe...
Join discussion