Count of titles held by our library. Unique titles?
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
How can we find the number of titles for our library? How about unique titles?
Resolution:
As described in KB 4088, the following SQL gives you the number of non-deleted titles:
abc01@ALEPH20> select count(*) from z13 where z13_title is not null;
**** Hit return to continue ****
COUNT(*)
----------
2058177
If you are a consortium and you have multiple bib records for the same title, the following SQL will give you the number of unique titles:
abc01@ALEPH20> select count(unique z13_title) from z13;
**** Hit return to continue ****
COUNT(UNIQUEZ13_TITLE)
----------------------
1912861
- Article last edited: 10/8/2013