On 12/5/2013 8:39 PM, Hayden Livingston wrote:
If I have my data structured like
Col1
"FooId", "Value1", "Value2", "Value3"
I can do group by (Col1) and show this data on a graph. Imagine Col1 is the
timestamp field, I could split it into hour groups and show rates of
somethings. Like orders per hour rate.
select ComponentId, OperationId, Value
from MyTable
where ColumnName = 'Col1';
would give you all orders together with their timestamps. Is that what
you wanted?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
