Re: [Koha] SQL - Library Books Investment by Collection Code
8 Dec
2017
8 Dec
'17
7:20 a.m.
Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (i686) using readline 6.3 (from About Koha page) Library Books investments by "Collection Code" for a single library/default library. ------------------------- SELECT ccode AS 'Collection Code', COUNT(DISTINCT items.biblionumber) AS 'No of Titles', COUNT(itemnumber) AS 'No of Volumes', SUM(price) AS 'Investment or total expenditure in Rs.' FROM items GROUP BY ccode ---------------------------- Output, https://ibb.co/kyRueb with thanks Satish
3060
Age (days ago)
3060
Last active (days ago)
0 comments
1 participants
participants (1)
-
SATISH