Search for a command to run...
Articles tagged with #mysql
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...
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...
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...
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...
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...
1. What is SELECT? The SELECT statement is part of DQL (Data Query Language).It is used to query and display data from tables. 👉 Think of it like a “search engine” for your database.It doesn’t change data, it only retrieves it. Basic syntax: SELECT ...