showing records question

[techlover]

Hello,

I have a table with 3 columns (active,tracking,name).

I want to get the count of all the records grouped by tracking. I am using:
select Count(*) from MyTable group by tracking

it returns:
9
8
2
1
1

Great but what is 9,8,2,etc?

How can I get this so I know what is what?

9 NAME
8 NAME
etc

THANKS!

[techlover]

opps. Nevermind.

I just did this:

select , Count() from HitLog group by track

and I got the full details 🙂