[thelist] SQL Group By question

Casey Crookston caseyc at IntelliSoftmn.com
Wed Dec 6 21:02:27 CST 2006

> If a table looks like this:
> ID         Name    Group
> 1          NameA Group1
> 2          NameB Group1
> 3          NameC Group2
> 4          NameD Group2
> Is it possible to build a query that would return these results:
> Group1
> NameA
> NameB
> Group2
> NameC
> NameD

>>no, you need program logic for that (or SQL extension from your
maybe with a cube, but its easier to do with programing.<<

Thanks Pedro and everyone else.  I threw these into a couple embedded
data readers and it turned out nicely. 



More information about the thelist mailing list