to count the data of a single

RohanJaiswal — Wed, 24 Apr 2013 06:12:58 +0000

to count the data of a single attribute we use count() function and to sort the data use order by function

To be honest for simplicity

Greg K — Thu, 10 May 2012 08:59:56 +0000

To be honest for simplicity save I would have broken them up to separate SQL statements, one to count (and group) by gender, and then a second one to count (and group) by hair.

-Greg

So I think I need to redesign

benf — Fri, 03 Feb 2012 16:41:47 +0000

So I think I need to redesign my database tables anyway actually. Gender and hair length should be in separate tables and be foreign keys in a new user table.