@Akash-GitaBhagwat
The people who are crazy enough to think they can change the world are the ones who do
Nothing here yet.
Nothing here yet.
Oct 7, 2025 · 5 min read · 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...
Join discussionSep 30, 2025 · 4 min read · Updated 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...
Join discussionSep 30, 2025 · 3 min read · MAX(), 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...
Join discussionSep 29, 2025 · 3 min read · GROUP 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...
Join discussionSep 29, 2025 · 4 min read · Sort, 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...
Join discussion