Aggregate Relational Algebra (Maximum)
You can very well express aggregate functions with only basic operators. It’s a pretty neat thing. Suppose we have a table T, and we’d like to find the maximum of its “value” field. First, we should take the cartesian product of T with itself — or rather with a copy of itself, T2. Then we … Read more