Count of titles held by our library. Unique titles?

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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