DF197: GROUP BY ALL clause is used.

Last modified: May 28, 2025

The topic describes the DF197 T-SQL code analysis rule.

Message

GROUP BY ALL clause is used.

It is not recommended to use the GROUP BY ALL clause as it is deprecated and provided for backward compatibility only.

SELECT code, SUM(VALUE) AS sum_value
FROM dbo.DemoTable
GROUP BY all code
GO

SELECT code, SUM(VALUE) AS sum_value
FROM dbo.DemoTable
GROUP BY code
GO

Was this page helpful?

Yes

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.