To group rows into subgroup by one or more values of columns we use MySQL GROUP BY.
Suppose in user table same country name exists for many times for different user. So if we use GROUP BY for country column to a SELECT query then only unique country will be listed.
SELECT * FROM users GROUP BY user_country;
It works same like DISTINCT operator. But the different is aggregate functions like SUM, AVG, MAX, MIN and COUNT are used by this clause.
The aggregate functions is used to perform calculation on each subgroup and return in a single value result for each subgroup.
SELECT COUNT(*) FROM users GROUP BY user_country;
will show the no of users for each unique country.
MySQL HAVING clause is used to filter conditions for group of rows. HAVING clause is used with the GROUP BY clause.
SELECT * FROM users GROUP BY user_country HAVING age > 18;
Introduction: The digital landscape is always evolving, and if there is one thing you can…
Forget all the big fancy words and tech hype around “Artificial Intelligence” for now. The…
Solar panels work by converting the solar energy received from the sun into usable electric…
In today’s digital-first economy, your website is often the first impression your business makes. Whether…
Dubai’s digital landscape is highly competitive, making it essential for businesses to work with the…
Are you planning to hire plumbers for repairing water lines, checking the level of your…