October 1, 2009 at 7:18 am
I also feels that answer is incorrect
as cube and rollup are already there in sql server 2005
October 1, 2009 at 7:37 am
I agree with the others as well. I think the wording of this question was misleading as CUBE and ROLLUP both existed as keywords previously just not in the same context as in SQL 2008. A better way of asking the question might have been, "What are all of the ways that you can group a set of fields in the GROUP BY clause in SQL 2008?" Something along that line. GROUPING_ID still would not have been a valid answer though as you cannot use that syntax in the GROUP BY clause.
October 1, 2009 at 7:43 am
Grouping_ID is not a sub clause, but a function.
Swarndeep
http://talksql.blogspot.com
October 1, 2009 at 7:50 am
This is straight from the link supplied in the answer.
SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the same query. These extensions are: the GROUPING SETS, CUBE, and ROLLUP subclauses of the GROUP BY clause and the GROUPING_ID function. The new extensions are standard and should not be confused with the older, nonstandard CUBE and ROLLUP options.
Even the answer points out that GROUPING_ID is a new function, not a subclause of the GROUP BY clause.
Greg
October 1, 2009 at 8:18 am
G² (10/1/2009)
This is straight from the link supplied in the answer.SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the same query. These extensions are: the GROUPING SETS, CUBE, and ROLLUP subclauses of the GROUP BY clause and the GROUPING_ID function. The new extensions are standard and should not be confused with the older, nonstandard CUBE and ROLLUP options.
Even the answer points out that GROUPING_ID is a new function, not a subclause of the GROUP BY clause.
Greg
You are exactly right. The question reads just like the documentation given and GROUPING_ID is a function not a subclause.
October 1, 2009 at 8:36 am
I am in the opinion of Grouping_ID is not a subclause of Group By. It is a function used in Select Statement for aggregation.
I believe the answer is GROUPING SETS, CUBE, and ROLLUP.
Dhans
October 1, 2009 at 9:38 am
G² (10/1/2009)
This is straight from the link supplied in the answer.SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the same query. These extensions are: the GROUPING SETS, CUBE, and ROLLUP subclauses of the GROUP BY clause and the GROUPING_ID function. The new extensions are standard and should not be confused with the older, nonstandard CUBE and ROLLUP options.
Even the answer points out that GROUPING_ID is a new function, not a subclause of the GROUP BY clause.
Greg
I fully agree with your reasoning.
Can't help the feeling that some QotDs are hurriedly researched and even more hurriedly worded--giving those who carefully weigh each word of the question, no chance at all to get it right.
Whatever, aren't we used to receiving blurry requests and then have to go figure how to implement it so that the requestor receives exactly what he/she had in mind? 😎
Michael
October 1, 2009 at 9:49 am
CUBE and ROLLUp are older than SQL 2008, Grouping_ID is a function and not a subclause of group by.
Hence Grouping Sets is the only new feature introduced to GROUP BY by SQL 2008.
October 1, 2009 at 11:13 am
G² (10/1/2009)
This is straight from the link supplied in the answer.SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the same query. These extensions are: the GROUPING SETS, CUBE, and ROLLUP subclauses of the GROUP BY clause and the GROUPING_ID function. The new extensions are standard and should not be confused with the older, nonstandard CUBE and ROLLUP options.
Even the answer points out that GROUPING_ID is a new function, not a subclause of the GROUP BY clause.
The question to me read
SQL Server 2008 introduces several extensions (subclauses), to the GROUP BY clause. Select all those that apply.
Was the question modified based on discussions here? If not, then I think based on the link the answer is correct. For CUBE & ROLLUP, the link says
The new extensions are standard and should not be confused with the older, nonstandard CUBE and ROLLUP options
October 1, 2009 at 11:43 am
rjv_rnjn
Was the question modified based on discussions here?
No it was not ... the question was designed to bring attention to the subtle changes made between 2005 and 2008. Too many people fixated on the word (subclauses) and not enough paid attention to the word extensions, which is at the heart of the question.
My favorite challenge to those who object is to ask them to compose a QOD and learn how difficult it is to satisfy everyone. Any one up to it?
October 1, 2009 at 12:19 pm
It may have been the intention to design the question in that way, but nothing in the question shows its heart to be about extensions any more than it is about subclauses. Personally I feel the extensions relate to the subject of the sentence - the GROUP BY clause, and the whole is governed by the phrase "SQL Server 2008 introduces", which clearly excludes keywords introduced with 2005.
Having said that, writing a QOD is difficult, and praise is due to all those who take the time to do so. The questions always help in some way, even if sometimes attention is drawn to the heart of the question for the wrong reason 🙂
October 1, 2009 at 1:37 pm
david.wright-948385
Having said that, writing a QOD is difficult, and praise is due to all those who take the time to do so. The questions always help in some way, even if sometimes attention is drawn to the heart of the question for the wrong reason
Thank you ...
October 1, 2009 at 2:43 pm
I would have to think the question if faulty in some way when close to 85% of the people answering it are getting it wrong.. IN my time here this is one of the most lopsided correct/incorrect percentage
October 1, 2009 at 4:25 pm
Steve Vassallo
would have to think the question if faulty in some way when close to 85% of the people answering it are getting it wrong
Can not agree with you Steve. I try to make my questions difficult on somewhat obscure aspects of SQL server... sort of separates the men with deep knowledge of the subject from those wanna be's.
In any case it gets them all to checking Books On Line, Technet, MSDN and maybe in doing so they learn a bit more -- which is the objective of the QOD. How many now realize that the CUBE and ROLLUP have changed since 2005 and a new function added?
October 2, 2009 at 12:09 am
This was removed by the editor as SPAM
Viewing 15 posts - 16 through 30 (of 45 total)
You must be logged in to reply to this topic. Login to reply