Is there any best way to write QUERY so we can get CEILING value in SQLite?
I have following solution which i feel not proper.
eq.
CONSIDEER field -> floatValue = 15.514
Select CASE WHEN floatValue -CAST(floatValue as int)>0 THEN CAST(floatValue as int)+1 ELSE floatValue END RESULT
Thanks in advance
Aucun commentaire:
Enregistrer un commentaire