<div>
Thank you. &nbsp;I knew I had to use a Group BY but didn't know where.
</div>


Thank you.  I knew I had to use a Group BY but didn't know where.

<div>
<div class="content wysiwyg-content">
I have a table that contains vehicle information for owners. &nbsp;The table has an ownerid to map vehicles to owners. &nbsp;What I need is a query that will tell me how many owners have more than 3 vehicles. &nbsp;I don't need the details, just the count. &nbsp;So for example:<br />
<br />
Vehicle Table<br />
VID &nbsp; &nbsp; &nbsp; OID<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300<br />
6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300<br />
7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300<br />
8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400<br />
9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400<br />
10 &nbsp; &nbsp; &nbsp; &nbsp; 400<br />
11 &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
12 &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
13 &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
14 &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
15 &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
16 &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
<br />
The SQL would return 2 - OID 300 and OID 500 have more than 3 vehicles. &nbsp;Can anyone help me with this? &nbsp;We are using MS SQL Server 2005.
</div>
</div>


I have a table that contains vehicle information for owners.  The table has an ownerid to map vehicles to owners.  What I need is a query that will tell me how many owners have more than 3 vehicles.  I don't need the details, just the count.  So for example:

Vehicle Table
VID       OID
1           100
2           100
3           200
4           300
5           300
6           300
7           300
8           400
9           400
10         400
11         500
12         500
13         500
14         500
15         500
16         500

The SQL would return 2 - OID 300 and OID 500 have more than 3 vehicles.  Can anyone help me with this?  We are using MS SQL Server 2005.

SQL help on a complicate query

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.