Home

Rule description

• Queries should not SELECT too many columns

Non-compliant Code Example

SELECT          --Non complaint code (Select query containing columns more then default defined limit of 6 columns)
    NAME,
    ADDRESS,
    CREDIT_LIMIT,
	AREA_CODE,
	PHONE_NUMBER,
	LANDMARK,
	TOTAL_EXPENSE
FROM
    CUSTOMERS
WHERE
	CREDIT_LIMIT IS NOT NULL