query of people in groups

Suppose I have a table named "Team". I would like to query this table so that it returns all people grouped by their team.  Can someone write this query, as I am stuck.


So here is my table



Team

1 | A  | Tony
2 | B  | Jim
3 | C  | Jake
4 | A  | Karen
5 | A  | Marcia
6 | B  | Rory
7 | C  | Jerry
8 | C  | Thomas


Here is the result of the query

1 | A  | Tony
4 | A  | Karen
5 | A  | Marcia
6 | B  | Rory
2 | B  | Jim
3 | C  | Jake
7 | C  | Jerry
8 | C  | Thomas
LVL 2
brgdotnetcontractorAsked:
Who is Participating?
 
lwadwellCommented:
Assuming the columns where called ID, Teamname and Name ...

SELECT ID, Teamname, Name
FROM team
ORDER by Teamname
0
 
brgdotnetcontractorAuthor Commented:
Duh, how obvious. I must have had a mental block. Thanks a bunch.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.