vendredi 29 janvier 2016

sqlite greater than or equal to 1 query not working

I have a table with field q4 as type integer(10) with default value 0.

I want results where q4 is greater than or equal to 1.

I have tried this in sqlite.

SELECT * FROM g101 WHERE  q4 >= 1

But it is showing two rows with value of 0.

Please help,

Thank in advance

Aucun commentaire:

Enregistrer un commentaire