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 percentageIs this a good way, or is there a better way? -- Cecil Westerhof

