Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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