Re: GROUP BY

Lennart <erik.lennart.jonsson_at_gmail.com> wrote in news:f2ph1v$u15$1_at_registered.motzarella.org:

> V.J. Kumar wrote:
> [...]

>>> 
>>> T431, "Extended grouping capabilities"
>>> 
>>> I believe this is the same feature as where group by grouping sets, 
>>> rollup and cube are defined.
>> 
>> What have 'extended grouping capabilities' got to do with the claim
>> that the simple 'group by' miraculously creates a tuple out of
>> nothing ? 

>>  It 
>> does not,  either in the implementations I referred to or in the '92 
>> standard.  Neither does it in '99, btw !  Also 'select 1 from t1
>> group by grouping sets ()' is syntactically incorrect in both
>> implementations. 
>> 

That is correct, although the correct syntax does not help you much with SQL Server because it does not have the 'grouping sets' functionality.

>
> which I imagine is the same as:
>
> select 1 from t1 group by ()

In other implemmentations in accordance with the 2003 standard, you will still obtain zero rows, either with 'group by ()' or 'group by grouping sets (())'. Not surprising really.

>
>
> /Lennart
Received on Sun May 20 2007 - 20:02:19 CEST