dynamobi/dynamobi — Issue #776: [FRG-94] Need to support empty set in GROUP BY
Author: dynamobi-build
Created: 2011-12-30 03:48:27+00:00
State: closed
Labels: FRG, SQL Validator

[reporter="jack", created="Wed, 22 Mar 2006 13:01:16 -0500 (GMT-05:00)"]
2003 spec allows for an empty group set by using an empty set of parens. Ex. SELECT deptno FROM emps GROUP BY ()

------- Comment #1 From Jack Frost 2005-03-08 17:50 [reply] -------

2003 SQL allows for specification of an empty set in a GROUP BY clause. The empty set is specified using an empty set of parens.Ex. SELECT deptno FROM emps GROUP BY ()

------- Comment #2 From Julian Hyde 2005-03-08 23:04 [reply] -------

JVS, fyi. I had never heard of this feature! Pays to read the spec, I guess.