You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Add "group" and "compute" clauses to "from" expression. The effect is aggregation and aggregate functions. With "group" you cannot use "yield", only "compute".
For example, the expression
from e in emps
group (#deptno e) as deptno
compute sum of (#id e) as sumId,
count of e as count
is equivalent to the SQL query
SELECT e.deptno, SUM(e.id) AS sumId, COUNT(*) AS "count"
FROM emps
GROUP BY e.deptno
The text was updated successfully, but these errors were encountered:
Add "group" and "compute" clauses to "from" expression. The effect is aggregation and aggregate functions. With "group" you cannot use "yield", only "compute".
For example, the expression
is equivalent to the SQL query
The text was updated successfully, but these errors were encountered: