SQL to get patrons with most loans
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
What SQL I can use to get:
A. the patron ID with most loans in xxx50?
B. all patrons who have more than X loans in xxx50?
Resolution:
This SQL will give you both of them:
SQL> select z36_id, count(*) from z36 group by z36_id order by count(*) desc;
- Article last edited: 10/8/2013