Non-select list Order By

On systems that allow it, having a column listed in the ORDER BY and not in the SELECT list broadens the scope of the query to include that column as well.

The column is NOT displayed in the results. Only the affected rows.

Previous slide

Next slide

Back to first slide

View graphic version