I need to have a CEIL function in SQLite. This is the way I implemented it:
WITH percentage AS (
    SELECT date
    ,           100.0 * rank / outOf         AS percentage
    ,      CAST(100.0 * rank / outOf AS int) AS castedPercentage
    FROM ranking
)
SELECT date
,      (CASE WHEN percentage = castedPercentage
           THEN castedPercentage
           ELSE castedPercentage + 1
       END) AS percentage
FROM percentage

Is this a good way, or is there a better way?

-- 
Cecil Westerhof

Reply via email to