Feel very magical, this order by this normal?

If the values are strings, the word should also can ORDER BY, without fully into 0 ah, look not to understand


The great god of why

CodePudding user response:

Sort the abnormal didn't understand what you want to express

CodePudding user response:

Sorting before there is no shortage of 0 data, after the sorting is 0, is this normal?

CodePudding user response:

If the statement is no problem, may be there is something wrong with the program, may also be something wrong with data import, you can try using a table, or reset the program, why, I guess one reason: you may perform this statement for many times, but did not show, when the last show a mistake, it is best to change a table first try,

CodePudding user response:

The building Lord, all the results of compare again,

CodePudding user response:

Descending a try, you it doesn't start,

CodePudding user response:

The default ascending sort order by grammar, because in this field there are many data value is 0, the default minimum when sorting, in ascending order row in front, naturally you saw before not to 0 data put down after the back, not they become zero, you can press Alt + Pgdn or Alt + look at the End, the hope can help you, I think I said is detailed enough,

CodePudding user response:

Sorted 0 in the front is very normal, as for other values behind, also didn't see it

CodePudding user response:

The building Lord, you are the execution result very normal ah,

Display and sorting, 0 in front,
Do not add sorting, randomly sort query results,

CodePudding user response:

The query of all data, and then in contrast

CodePudding user response:

ORDER BY role for sorting, when you use the ORDER BY 0 is on the front (the remaining part of the data did not show, need to click the show all records), so you'd think becomes zero

CodePudding user response:

The ORDER BY AA DESC descending ORDER