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

    SQL-question regarding "number of active users within 2014 sorted by gender"

     

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

     


    Question    
    SQL statement needed for "number of active users within 2014 sorted by gender".

     

    Answer    
    The following request started in the USR library should bring the correct result (please replace usm50 with your adm library name):

    usr00@ALEPH221> select Z303_GENDER,count(*) from z303
    2 where (select count(*) from usm50.z35
    3 where z35_id = Z303_rec_key and
    4 Z35_EVENT_DATE >= 20140000 and
    5 Z35_EVENT_DATE <= 20149999 )
    6 > 0
    7 group by Z303_GENDER;


     

     

     


    • Article last edited: 26-Jun-2016