Correction - Needs another bracket to read:

select unit, (bit_position / 8) AS byteNo, (sum(1 << (bit_position % 8))) AS byteVal from table1 where val group by unit, (bit_position / 8);



On 2016/10/17 5:04 PM, R Smith wrote:

select unit, (bit_position / 8) AS byteNo, (sum(1 << (bit_position % 8)) AS byteVal from table1 where val group by unit, (bit_position / 8);


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to