[Koha] Top Borrowers for a given period

Indranil Das Gupta indradg at gmail.com
Sat Oct 3 21:11:07 NZDT 2015


Hi,

On Sat, Oct 3, 2015 at 12:40 PM, Admire Mutsikiwa
<amutsikiwa at uzlib.uz.ac.zw> 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


More information about the Koha mailing list