tag:blogger.com,1999:blog-6082652835152798567.post1386666798550019307..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Grouping Sets in SQL ServerUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6082652835152798567.post-40829996932367253022020-05-12T04:48:12.800-07:002020-05-12T04:48:12.800-07:00grouping (country) : only groups country data (not...grouping (country) : only groups country data (not null)<br />grouping (gender) : only groups gender data (not null)<br />if gender is first column then it would be country in grouping at last.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-22397350666434403552018-10-29T00:22:01.198-07:002018-10-29T00:22:01.198-07:00Please look result set before and after applying ...Please look result set before and after applying gender column in order by clause ...then you will understand the role of gender DotnetMaterial.Subbiahhttps://www.blogger.com/profile/05339960898591915702noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-55235445847137912812018-02-12T08:59:43.001-08:002018-02-12T08:59:43.001-08:00Sir ,
Order By Grouping(Country), Grouping(Gender)...Sir ,<br />Order By Grouping(Country), Grouping(Gender), Gender<br />what is role of last Gender without grouping i think result will be same with or without gender.Anonymoushttps://www.blogger.com/profile/17158660975778086271noreply@blogger.com