SQLite COUNT as type cast -

SQLite COUNT as type cast -

i wondering if possible cast integer gotten count real

something next (though doesn't work)

select cast (count (columna) count) real) table1 ....

i can convert count int real externally sql cutting downwards on steps need perform.

a column alias must come after entire expression:

select cast(count(columna) real) count ...

sqlite