[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
database)
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.
http://dev.norfire.com/Default.aspx?tabid=84
Thanks!
More information about the thelist
mailing list