Posted by kasterborus on 08/22/06 22:53

My query returns a table of results, I would like to add a count column
that contains the number of each result type returned.

i.e.

Type Count
1 3
1 3
1 3
2 2
2 2
3 4
3 4
3 4
3 4
4 2
4 2

Because there are 3 of type 1, 2 of type 2, 4 of type 3 etc...

Is there straightforward way of doing this in SQL?

Thanks

• Next in forum: Re: Trying to do REALLY simple procedure and loop in SQL Server
• Prev in forum: Re: Viewing transactions in SQL server 2005 express
• Thread view: How do I get a count of each set of results?

[Reply to this message]