Works great...Thanks. I used COUNT(CNT) because I already had CNT defined and since the (1=1) returns as a 1, it was functionally the same ...but both worked fine.
George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Brian Leach > Sent: Friday, April 15, 2011 9:39 AM > To: 'U2 Users List' > Subject: Re: [U2] Can this be done with SQL? > > George > > You need the HAVING clause to filter that way (and remember you can use > COUNT(*) to get a count): > > >SELECT GENRE, COUNT(*) FROM BOOK_TITLES GROUP BY GENRE; > Genre..... COUNT ( * ) > > BIOGRAPHY 2 > BUSINESS 8 > CLASSIC 31 > CRIME 1 > DRAMA 15 > FANTASY 68 > FICTION 97 > HISTORY 9 > HUMOUR 17 > LANGUAGE 2 > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
