<div>
No subqueries needed in this case:<br />

<pre><code id="code-20-40797164-1">SELECT PersonID, count(PersonId) AS Tot FROM personprogram GROUP BY PersonID HAVING Tot &gt;1</code></pre>
</div>


No subqueries needed in this case:


SELECT PersonID, count(PersonId) AS Tot FROM personprogram GROUP BY PersonID HAVING Tot >1

<div>
<div class="content wysiwyg-content">
I believe that I need to use a subquery to find a solution to my little problem, but it's been so long since I took my DB class that I don't remember too much. <br />
<br />
I have a table to which we can call personprogram. This table contains among other data, status, category, id, etc. What I want to find out, are persons who have more than one program in their record:<br />
<br />
PersonID &nbsp; Category &nbsp; Status<br />
100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
<br />
So my query would only return two IDs, 100 and 102. <br />
<br />
Not sure if a subquery is needed or a group by or having, Need to take a refresher course obviously. Thanks!
</div>
</div>


I believe that I need to use a subquery to find a solution to my little problem, but it's been so long since I took my DB class that I don't remember too much. 

I have a table to which we can call personprogram. This table contains among other data, status, category, id, etc. What I want to find out, are persons who have more than one program in their record:

PersonID   Category   Status
100             1                 1
100             2                 1
101             2                 1
102             1                 1
102             2                 1

So my query would only return two IDs, 100 and 102. 

Not sure if a subquery is needed or a group by or having, Need to take a refresher course obviously. Thanks!

Using subqueries

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.