Hi, On Sat, Oct 3, 2015 at 12:40 PM, Admire Mutsikiwa <[email protected]> wrote: > Hi > > > > I have a Children's Community Library which is trying to promote a reading > culture among its patrons by giving prizes to top borrowers. Given this > backdrop, I am interested in an SQL reports that will enable the library to > get Top X e.g. Top 10 borrowers for a given period.
Passing a value to the LIMIT parameter in the SQL may do the trick for you. cheers -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
