RE: [sqlite] sql query required

Hi Phanisekhar Try this query.. Select yearofbirth, count(yearofbirth) from group by yearofbirth; -Original Message- From: B V, Phanisekhar [mailto:[EMAIL PROTECTED] Sent: Friday, July 27, 2007 8:31 PM To: sqlite-users@sqlite.org Subject: [sqlite] sql query required Suppose I have a

Re: [sqlite] sql query required

Try SELECT Count(Name) FROM tablename GROUP BY yearofbirth On 7/27/07, B V, Phanisekhar <[EMAIL PROTECTED]> wrote: > Suppose I have a table: > > > > Create table "yearofbirth INTEGER, Name string" > > > > What will be the query to identify how many people were born in > different years? The outpu

[sqlite] sql query required

Suppose I have a table: Create table "yearofbirth INTEGER, Name string" What will be the query to identify how many people were born in different years? The output should contain all the years that are present in the table and the total count corresponding to each entry. Eg: 1901