|
well i dont know if the syntax is the same or
different but heres how you would do it in r:base
this is assuming your table is called visits and it
has 2 members, clientid integer and lastvisit datetime:
create view visitcounts as select clientid
count(clientid) from visits group by clientid
what that will do is give you 1 row per clientid
and the second column will be how many times they have visited.
is that what you were looking for or not
quite?
----- Original Message -----
Sent: Tuesday, December 02, 2003 5:30
PM
Subject: Re: Witango-Talk: Incremental
Count of Subgroup Instances
MS-SQL
Alan Wolfe wrote:
Hey Charles,
sounds like you are in need of a view.
what database are you using?
----- Original Message -----
From: "Charles Brown" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 5:16 PM
Subject: Witango-Talk: Incremental Count of Subgroup Instances
This has got to be easier than I am making it. I have a table of client
id numbers and their visit dates. I need to sort by the client id and
date and assign the number of their visit - from 1 to n. - in a visit#
field on the corresponding row in the table. So, for example, visit #4
for Fred was on 12/21/2003. Please speak real slow when responding to
this request for assistance. I am not real quick on the uptake today.
Oh yeah, the table has over 90,000 records in it, so I can't just give
up and do it by hand.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to
http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
|
