|
Sqlite3 help with descending order
|
|
Your "numbers" are stored as TEXT. So it is sorted as text. You either need to change the field type. Or if you HAVE TO store value as text (why?), cast it to INTEGER when query
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link Create MCV example Debug small programs |
|
|
| Messages In This Thread |
|
Sqlite3 help with descending order - by I_Am_Groot - May-17-2019, 06:09 AM
RE: Sqlite3 help with descending order - by buran - May-17-2019, 06:45 AM
RE: Sqlite3 help with descending order - by I_Am_Groot - May-17-2019, 07:01 AM
RE: Sqlite3 help with descending order - by buran - May-17-2019, 07:17 AM
RE: Sqlite3 help with descending order - by I_Am_Groot - May-18-2019, 12:45 AM
|
| Possibly Related Threads… | |||||
| Thread | Author | Replies | Views | Last Post | |
| How to sort values descending from a row in a dataframe using python | sankarachari | 1 | 1,453 |
Aug-16-2021, 08:55 AM Last Post: jamesaarr |
|
