Re: GROUP BY

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 - 16:31:50 CEST