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]
