Home

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)