[thelist] SQL Group By question

Casey Crookston caseyc at IntelliSoftmn.com
Wed Dec 6 13:54:08 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

 

Thanks,

 

Casey

 




More information about the thelist mailing list