• 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