Home
Queries should not SELECT too many columns
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