Database Engine built in Java.
1
vote
0answers
29 views
parenthetic grouping of join clauses
What is the difference between these joins?
a left join b left join c
(a left join b) left join c
a left join (b left join c)
Does the grouping only affect the order of the joins? Will the query ...
0
votes
1answer
42 views
H2 SELECT NULLABLE or other equivalent to check a column has NOT NULL constraint or not
I would like to check if a column has a NOT NULL constraint in order to start an automated upgrade of the table definition.
However in H2 the SQL SELECT NULLABLE FROM TABLE_NAME doesn't return me the ...
1
vote
1answer
55 views
How to aggregate datapoints in a table?
Suppose I have following table -
CREATE TABLE data_points (t DATETIME PRIMARY KEY, value INTEGER);
I want to aggregate the data by calculating average of every 10 points in the table.
i.e. If ...
