Determining Number of Patrons Added to Database Since a Certain Date
- Article Type: General
- Product: Aleph
Is there an SQL command we can use to determine how many new patrons of each patron type have been added to our database since a certain date or between certain dates?
We would like to know how many new patrons of each patron type we have registered since opening our new facility last September.
The following SQL can be used to get you this count:
> s+ abc50
SQL> select z305_bor_status, count(*) from z305 where z305_open_date >= '20080901' group by z305_bor_status;
- Article last edited: 10/8/2013