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
Description
How can we find the records with the most items attached to them?
Resolution
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