Text sorting compares character by character according to character code. That is why Wireless Mouse comes before Water Bottle: both names start with W, and the decision falls to the second character, where i is greater than a. In DESC order, the greater one comes first.

In this text comparison, uppercase letters are greater than lowercase letters, so a name starting with an uppercase letter would appear before one starting with a lowercase letter. In this table all the names start with an uppercase letter, so the point does not affect the result.

A common mistake: expecting text sorting to behave like numeric sorting when there are digits inside the string. The value Monitor 27 is sorted by its characters, and if there had been two products named Monitor 9 and Monitor 27, the 9 would have come after the 27.

loading…

the question