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
