Thread: ORDER BY two columns gives incorrect result on second column

ORDER BY two columns gives incorrect result on second column

From
peacefultraveler
Date:
Hello,
I'm working through a tutorial that calls for a ORDER BY on two columns. The first column sorts correctly, but the second one doesn't:

image.png

This is running on Windows 11, and the version is:

image.png


Attachment

Re: ORDER BY two columns gives incorrect result on second column

From
"David G. Johnston"
Date:
Behaving correctly for your data.

The spelling of the school name in the final row is capital M, capital I; there is no tie to break from the prior two rows where the I is lowercase.


David J.


On Monday, May 13, 2024, peacefultraveler <peacefultraveler@proton.me> wrote:
Hello,
I'm working through a tutorial that calls for a ORDER BY on two columns. The first column sorts correctly, but the second one doesn't:

image.png

This is running on Windows 11, and the version is:

image.png


Attachment