Column should be in group by clause
Reports columns that are not in the GROUP BY clause or inside an aggregate function call.
Example (Microsoft SQL Server):
CREATE TABLE t1 (a INT, b INT);
SELECT a, b FROM t1 GROUP BY a;
If you run the SELECT query, you will receive an error because Microsoft SQL Server expects the b column in GROUP BY or used inside an aggregate function. The following two examples will fix the error.
SELECT a, b FROM t1 GROUP BY a, b;
SELECT a, max(b) max_b FROM t1 GROUP BY a;
Inspection Details | |
|---|---|
Available in: | AppCode 2023.3, CLion 2023.3, DataGrip 2023.3, DataSpell 2023.3, GoLand 2023.3, IntelliJ IDEA 2023.3, JetBrains Rider 2023.1, PhpStorm 2023.3, PyCharm 2023.3, Qodana for .NET 2023.1, Qodana for JVM 2023.3, Qodana for PHP 2023.3, Qodana for Ruby 2023.3, RubyMine 2023.3 |
Plugin: | Database Tools and SQL, 233.SNAPSHOT |
Last modified: 13 July 2023