Hi
How do I add a constant field to a select query? I want to be able to do something like :-
select max(“field1”) as “max_f1”, max(“field2”) as “max_f2”, ‘max’ as “StatName” into “downsampled_table” from “table” group by time(), “StatName”
select min(“field1”) as “min_f1”, min(“field2”) as “min_f2”, ‘min’ as “StatName” into “downsampled_table” from “table” group by time(), “StatName”
