nucleusss.hashnode.dev🔗 Understanding Joins in MySQL (INNER, LEFT, RIGHT & FULL OUTER JOIN)all types of JOINS in MySQL 📅 Date: 7th October 2025In this post, we’ll explore all types of JOINS in MySQL — how they work, when to use each, and common mistakes to avoid. 🧩 What is a JOIN? A JOIN in SQL is used to combine data from two or more r...Oct 7, 2025·5 min read
nucleusss.hashnode.dev🔗 Aggregate Functions (MAX, MIN, GROUP_CONCAT) and JOINS in MySQLUpdated In our previous article, we learned about GROUP BY, HAVING, and basic aggregate functions (COUNT, SUM, AVG). Today, we’ll move forward with: More aggregate functions: MAX, MIN, GROUP_CONCAT An introduction to JOINS Let’s explore with prac...Sep 30, 2025·4 min read
nucleusss.hashnode.dev🔗 Aggregate Functions (MAX, MIN, GROUP_CONCAT) and JOINS in MySQLMAX(), MIIN(), JOIN In our previous article, we learned about GROUP BY, HAVING, and basic aggregate functions (COUNT, SUM, AVG). Today, we’ll move forward with: More aggregate functions: MAX, MIN, GROUP_CONCAT An introduction to JOINS Let’s explo...Sep 30, 2025·3 min read
nucleusss.hashnode.dev📊 Mastering GROUP BY, HAVING & Aggregate Functions in MySQLGROUP BY Clause, HAVING Clause… When working with databases, we often need to summarize data—like counting employees in each department, finding the total salary paid, or checking which age group has the most employees. In MySQL, this is achieved wit...Sep 29, 2025·3 min read
nucleusss.hashnode.dev🚀 SQL SELECT, Logical Operators, Sorting, LIMIT & OFFSET — With Examples & Common MistakesSort, Limit, Offset, Logical Operators Learning SQL is all about practice. While working with a sample table called staff, I explored SELECT queries, logical operators, sorting, LIMIT, and OFFSET. In this blog, I’ll explain each concept with examples...Sep 29, 2025·4 min read