<div>
you have to &quot;distinct&quot; first:<br />

<pre><code class="code-1 nolinks" id="code-20-40488263-1"><span>select name , count(*)</span>
<span>  from ( select id, name from yourtable group by id, name )</span>
<span>group by name</span>
</code></pre>
</div>


<div>
I am getting this error &quot;Every derived table must have its own alias&quot;. What does this mean?
</div>


<div>
<div class="content wysiwyg-content">
I have a table as follows:<br />
<br />
<u>id</u> &nbsp; &nbsp; &nbsp; <u>name </u><br />
1 &nbsp; &nbsp; &nbsp; &nbsp;Complete<br />
2 &nbsp; &nbsp; &nbsp; &nbsp;Incomplete<br />
2 &nbsp; &nbsp; &nbsp; &nbsp;Incomplete<br />
1 &nbsp; &nbsp; &nbsp; &nbsp;packaged<br />
3 &nbsp; &nbsp; &nbsp; &nbsp;complete<br />
4 &nbsp; &nbsp; &nbsp; &nbsp;packaged<br />
4 &nbsp; &nbsp; &nbsp; &nbsp;packaged<br />
<br />
How can I do a count statement to get the following output:<br />
complete &nbsp;2<br />
incomplete 1<br />
packaged 2<br />
<br />
The reason that &quot;incomplete&quot; is 1 is because it is grouped by id, the same is with &quot;packaged&quot;. &nbsp;Can someone let me know how I can get a count of &quot;name&quot; &nbsp;by grouping by 'id&quot; ?<br />
<br />
Thank you,<br />
A
</div>
</div>


I have a table as follows:

id       name 
1        Complete
2        Incomplete
2        Incomplete
1        packaged
3        complete
4        packaged
4        packaged

How can I do a count statement to get the following output:
complete  2
incomplete 1
packaged 2

The reason that "incomplete" is 1 is because it is grouped by id, the same is with "packaged".  Can someone let me know how I can get a count of "name"  by grouping by 'id" ?

Thank you,
A

mysql count and group by

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.