Solved

Select Count of distinct items

Posted on 2008-10-29
1
159 Views
Last Modified: 2012-05-05
I need a SQL statement.

I have a MS Access Table with a "Status" field (column).

There could be any number of distinct values in the Status field

Example

Trader
Keeper
Loaner
etc.

How can I get the totals of each of these from the status field of the table?

Example:

Trader 20
Keeper 9
Loaner 31
etc

thanks

0
Comment
Question by:geocoins-software
1 Comment
 
LVL 9

Accepted Solution

by:
jamesgu earned 250 total points
ID: 22833690
select status, count(*)
from <table>
group by status
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql help 8 55
SQL Server 2012 r2 - calculations/operation on many Temp Tables 6 21
Query Syntax 17 36
I have a SQL Select with a where clause that has an issue. 6 41
In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question