<div>
something like this:<br />
<br />
<br />
SELECT COUNT(*) As Total, SubCat<br />
FROM Table<br />
GROUP BY SubCat
</div>


something like this:


SELECT COUNT(*) As Total, SubCat
FROM Table
GROUP BY SubCat

<div>
<div class="content wysiwyg-content">
I have a table with a &quot;Cat&quot; field and a &quot;SubCat&quot; field.<br />
<br />
I need a SQL query which returns the distinct SubCats for a given Cat and the total number of SubCats found for each distinct SubCats<br />
<br />
My Table:<br />
<br />
Cat &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Subcat &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
-------- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;----------<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3<br />
<br />
<br />
I want the query to return the distinct Subcats with totals for the given cat. Thus if my Cat was 1 as in the above example, I want the query to return:<br />
<br />
Subcat &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Total<br />
-------- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ---------<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />

</div>
</div>


I have a table with a "Cat" field and a "SubCat" field.

I need a SQL query which returns the distinct SubCats for a given Cat and the total number of SubCats found for each distinct SubCats

My Table:

Cat                    Subcat          
--------              ----------
1                        1
1                        2
1                        3
1                        3


I want the query to return the distinct Subcats with totals for the given cat. Thus if my Cat was 1 as in the above example, I want the query to return:

Subcat           Total
--------           ---------
1                   1
2                   1
3                   2


DISTINCT Query with totals

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.