Re: Aggregates, views, and subselects

[Scott Salisbury]

David Ebert wrote:

 Getting the sum of services by week number is easy enough (sele sum...group
by), but I'm having no luck trying to figure out how to count the records in
the clients table for the unduplicated count of open cases for each service
week.

SELECT COUNT (DIST CaseNumber), WeekNumber +
  FROM Service +
  GROUP BY WeekNumber

Scott
====
Scott J. Salisbury
Matrix Data Systems / The R:Street Journal
5114 Point Fosdick Drive NW, Suite E-272
Gig Harbor, WA 98335-1733

E-Mail Address: [EMAIL PROTECTED]
Temporary URL: www.seanet.com/~sjs  (downloads available)
New Web Address: www.rStreetJournal.Com
Direct Line: 206-423-7679
Toll Free: 888-386-5040
Seattle: 206-448-7975
Fax: 305-425-0491