Question: SQLITE order by numeric and not alphabetic

Question

SQLITE order by numeric and not alphabetic

Answers 2
Added at 2017-09-28 12:09
Tags
Question

When I order my database SQLITE by Classement I have this :

Classement | Nom
1          | clem
10         | caro
11         | flo
12         | raph
2          | prisc
3          | karim
4          | prout

I would like to get :

Classement | Nom
1          | clem
2          | prisc
3          | karim
4          | prout
10         | caro
11         | flo
12         | raph

Here is my code :

SELECT t.Classement 
FROM tableau t 
WHERE 1 = (SELECT 1 + COUNT (*) FROM tableau t2 WHERE t2.Classement < t.Classement OR ( t2.Classement == t.Classement AND t2.Nom < t.Nom ))

Can anyone help me ? Thank you!

Answers to

SQLITE order by numeric and not alphabetic

nr: #1 dodano: 2017-09-28 12:09

I guess column Classement is not an integer but character.

So try this SELECT * FROM tableau order by cast(Classement as integer)

nr: #2 dodano: 2017-09-28 13:09

You get alphabetic order if the values are strings.

To change the table so that all Classement values are numbers, ensure that the column type is not a text type, and use this:

UPDATE tableau SET Classement = CAST(Classement AS NUMBER);
Source Show
◀ Wstecz