Home
ROWNUM should not be used at the same query level as ORDER BY
Rule description
- ROWNUM should not be used at the same query level as ORDER BY
Non-compliant Code Example
SELECT NAME, ADDRESS, CREDIT_LIMIT FROM CUSTOMERS WHERE ROWNUM <= 5 --Non compliant code (ROWNUM is used at the same query level as ORDER BY) ORDER BY CREDIT_LIMIT;