Re: GROUP BY

From: Lennart <erik.lennart.jonsson_at_gmail.com>
Date: Sat, 19 May 2007 16:31:50 +0200
Message-ID: <f2n1on$m8d$1@registered.motzarella.org>

V.J. Kumar wrote:
[...]
>> SELECT 1
>> FROM r
>> GROUP BY ();
>>
>> returns a single tuple even if r is empty.
>
> What SQL would that be?

The following feature outside Core SQL-99 is used:

T431, "Extended grouping capabilities"

I believe this is the same feature as where group by grouping sets, rollup and cube are defined.

/Lennart

PS, Mimer (or whatever the are called these days) has a sql validator where one can test conformance against different versions of sql:

http://developer.mimer.com/validator/index.htm

DS.

[...] Received on Sat May 19 2007 - 09:31:50 CDT