Counting items and returning values

  • Thread starter Thread starter Andrew Banks
  • Start date Start date
A

Andrew Banks

I have a table of product orders. It contains a row for "platform" and I
need to return how many times each platform is listed in the DB

Example data for platform could be:
XBOX
XBOX
XBOX
PLAYSTATION
PLAYSTATION
GAMECUBE
PLAYSTATION

I'd like the data to be returned as

XBOX - 3
PLAYSTATION - 3
GAMECUBE - 1

How would I go about doing this please?
 
Depends on what you mean by "in the database". If the data are kept in one
table, then the following would do it:

select
Platform
, count (*)
from
MyTable
group by
Platform


--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql


I have a table of product orders. It contains a row for "platform" and I
need to return how many times each platform is listed in the DB

Example data for platform could be:
XBOX
XBOX
XBOX
PLAYSTATION
PLAYSTATION
GAMECUBE
PLAYSTATION

I'd like the data to be returned as

XBOX - 3
PLAYSTATION - 3
GAMECUBE - 1

How would I go about doing this please?
 
This is more of an SQL question, so please post in relevant groups only.

Anyways, the answer to your question in q SQL query that return the count of
each platform:

SELECT Platform, Count(*) AS PlatformCount FROM myTable GROUP BY Platform
 
if the name of the column is "name":
SELECT name, COUNT(name)
GROUP BY name

HTH,
-Cliff
 
Back
Top