mardi 23 juin 2015

Is there any best way to write QUERY so we can get CEILING value in SQLite?

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