Home

GROUP BY should not be used in SQL SELECT statements

Rule description

  • GROUP BY should not be used in SQL SELECT statements

 

Non-compliant Code Example

SELECT
    NAME as nameCol,
    ADDRESS as addressCol,
    CREDIT_LIMIT as creditLimitCol,
	City
FROM
    CUSTOMERS
Group By City --Non compliant code (Group By clause should not be used)
Visual Expert 2020
 VEPLSQLRULE166