Re: [GENERAL] Running/cumulative count using windows

2010-03-30 Thread A. Kretschmer
In response to Oliver Kohll - Mailing Lists : > Hello, > > I'm still reasonably new to windowing functions, having used a few since 8.4 > came out. I wonder if anyone can help with this one. > > I've got a table of email addresses in a CRM system similar to the following: > > CREATE TABLE test(

[GENERAL] Running/cumulative count using windows

2010-03-30 Thread Oliver Kohll - Mailing Lists
Hello, I'm still reasonably new to windowing functions, having used a few since 8.4 came out. I wonder if anyone can help with this one. I've got a table of email addresses in a CRM system similar to the following: CREATE TABLE test( signup_date timestamp, email_address varchar(1000) ); INS