In Sql database management Groups By is used as clause which is used for return the selected set of rows into a set of summary rows by the values of one or more columns or expressions in SQL Server 2016 and One row is returned for each group. In the database Sql Query the Aggregate functions which is used in the SELECT clause <select> that provide list information about each group instead of individual rows. The Groups By clause has an ISO-compliant syntax and a non-ISO-compliant syntax that have one syntax style can be used in a single SELECT statement. Use the ISO compliant syntax for all new work. The non-ISO compliant syntax is provided for backward compatibility.