Re: Puzzle: What should this query return?

Either T is a grouped table, or the query is syntactically incorrect. By definition, a grouped query without a group by clause will result in one group, whether this group is empty or not.

My 2 cents,
Gert-Jan

Steve Kass wrote:
>
> Peter,
>
> The only standard I have a copy of is SQL-92, and I was looking at 7.9.syntax rules.7
> and 7.9.general rules.1. But now I see that the first mention of <grouped table> allows
> a <grouped table> with no GROUP BY clause, and I can't find enough yet to determine
> whether or not T is a grouped table or not. If it is, then is there one group with zero
> rows or no groups? There's still the chance that the value of 12 on a group of zero rows is 12,
> and it doesn't seem sensible that the two columns of this query produce different numbers
> of results. I'm still reading.
>
> Steve
Received on Sun Jun 30 2002 - 23:26:28 CEST