group by clause

In the SQL SELECT Statement we can also group data upon certain conditions, the GROUP BY condition can only be applied if we have redundant values in at least one column upon which we can group things.

If every column of each row has unique value then the GROUP BY clause will not group any thing together and will not give proper results.

The GROUP BY clause also requires the use of an aggregate function, which does some mathematical calculations upon the grouped data.