Home
Queries should not SELECT too many columns
Rule description
- Queries should not SELECT too many columns
Non-compliant Code Example
SELECT --Non compliant 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