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;
For any types of queries, you can contact us on info[at]namasteui.com.
Dog walking is an excellent way to maintain your furry friend's camaraderie and provides many…
Introduction Businesses understand the diverse requirements of mobile applications, which provide a competitive advantage. There…
The Internet of Things (IoT) has recently changed the world. It links gadgets together and…
NFTs, or Non-Fungible Tokens, are revolutionizing the digital economy. These unique digital assets, authenticated through…
Sinus infections, impacting approximately 31 million Americans each year, represent a significant health concern stemming…
No doubt that balanced weight is the key to wellness. So, when it comes to…