Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

COUNT() function and scope

Sep 17, 2003, 8:59 AM
kellogs
New User (2 posts)
Sep 17, 2003, 8:59 AM
Views: 7940
Shortcut
Quote Reply
COUNT() function and scope
Hi. I work with kbSQL and I'm having a problem with using count()...

I have to run totals for each type of exam, then the totals of all exams for a given time period that meet some other criteria also... I'm using the count() statement to do this, but when I get to the end and I try to use the count() to give the total of all exams, it just repeats the value of the last row... is there any way I can make the scope for the count() statement global when I do it in my final event?
Subject Author Views Date
Thread COUNT() function and scope kellogs 7940 Sep 17, 2003, 8:59 AM
Thread Re: [kellogs] COUNT() function and scope 		Andy 7747 Sep 17, 2003, 9:02 AM
Thread Re: [Andy] COUNT() function and scope 		kellogs 7734 Sep 17, 2003, 9:29 AM
Post Re: [kellogs] COUNT() function and scope 		Stealth 7651 Sep 17, 2003, 11:13 AM