• 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