Re: Counting records - items

Posted by Verus Open Source Support on Sep 20, 2011; 7:37am
URL: http://ngl.70.s1.nabble.com/Counting-records-items-tp6811195p6811242.html

Get count of items
select count(*) from document;

Count of titles
select count(*) from cataloguerecord;

Count of volumes
select count(*) from cat_volume;

On 09/20/2011 12:54 PM, nsid [via NewGenLib] wrote:

Hi all,

Is there any easy way to count the total number of:

1) the records
2) items

in the database?

Maybe an SQL query?

Thank you.

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Counting-records-items-tp6811195p6811195.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.