Difference Between Where and Group By Clause

The WHERE Clause

The WHERE Clause generally is used to filter the rows from a table on a specific condition. WHERE clause specifies search conditions for the rows returned by the Query and limits rows to a specific row set. If a table has a huge amount of records and if someone wants to get the particular records then using the ‘where’ clause is useful. The Syntax of the WHERE Clause is...

The GROUP BY Clause

Group by clause is used to group rows by one or more columns . Group by Clause is used with aggregate functions like SUM(), AVG(), MIN() etc. GROUP BY clause summaries identical rows into a single/distinct group and returns a single row with the summary for each group, by using appropriate Aggregate function in the SELECT list, like COUNT(), AVG(), SUM(), MIN(), MAX(), etc. The Syntax of the GROUP BY Clause is...

How Group By Clause is used with Having Clause?

Having clause is used to filter values in Group By clause. We will see how this works with the help of an example. The below query filters out some of the rows...

Difference Between Where and Group By Clause

Where Clause Group by Clause Where Clause is generally used to filter the rows from a table based on a specific condition. Group by clause is used to group rows by one or more columns. It does not involve an aggregate function. It involves aggregations functions like SUM(), AVG(), COUNT(),MAX() etc. Where clause is used with select, update, and with delete statements. It is used only with select statements. Its affected individual rows. It affects the whole group of rows to perform aggregate functions. It does not involve having clause. It involves having clause....

Conclusion

In this article, we have concluded that WHERE is used to filter records before any groupings take place that is on single rows, GROUP BY aggregates/ groups the rows and returns the summary for each group and HAVING is used to filter values after they have been grouped....