Thanks Rich, don't think I explained myself very well though. What I'm trying to do is:
SELECT myValue, COUNT(myValue) AS Whatever FROM myTable Where myValue=1 (and then on up to 5) Then output the count as a percentage of the whole recordcount. I realise I could loop it from 1 to 5 but myValue is already being looped and I'm going to end up with a silly amount of queries generated Cheers d ----- Original Message ----- From: "Rich Wild" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 3:12 PM Subject: RE: [ cf-dev ] percentages of values in recordset > SELECT myValue, COUNT(myValue) > FROM myTable > GROUP BY myValue > > > -----Original Message----- > > From: Damian Watson [mailto:[EMAIL PROTECTED] > > Sent: 11 June 2003 15:21 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] percentages of values in recordset > > > > > > Hi, > > > > Pretty dumbass question but I'm working on a poll where for > > instance I have > > a column with 5 possible values (1 to 5). > > > > Say there are 50 records. How do I get the number of records > > for each value > > without doing 5 queries? > > > > Cheers > > d > > > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
