Given a TABLE mytable
with a column of TEXT name
containing VALUES 1, 2, 2b, 2c, 3
. How do you select the maximum INT value in SQLite?
-- Does not work in SQLite
SELECT MAX(VAL(textcol)) FROM mytable;
Took me some time to find as I kept falling on instructions for other SQL syntaxes.
Aucun commentaire:
Enregistrer un commentaire