Code Inspection: Redundant ordering direction
Reports redundant ordering directions like ASC and DESC in ORDER BY clauses.
Example (MySQL):
CREATE TABLE foo(a INT, b INT, c INT);
SELECT * FROM foo ORDER BY a ASC, b DESC, c ASC;
The ORDER BY keyword sorts the records in the ascending order by default. So, the
ASC keyword for a and c columns is redundant.Suppress an inspection in the editor
Position the caret at the highlighted line and press Alt+Enter or click
.Click the arrow next to the inspection you want to suppress and select the necessary suppress action.
Last modified: 16 July 2021