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

    How to find Bib/ADM records with more than nnn items


    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care



    How can we find the records with the most items attached to them?


    The following SQL can be used to find the largest number of items for a particular ADM record, in ascending order, ending with the ADM with the largest number of items:

    > s+ xxx50
    SQL> select substr (z30_rec_key,1,9), count(*) from z30 group by substr (z30_rec_key,1,9) having count(*) > 300 order by count(*) ASC;

    [The "300" can be increased to limit the results to larger numbers of items.]


    • Article last edited: 12-Mar-2017