> I have a question about GROUP BY / HAVING. It seems I can't do
> something I *think* I should be able to do!
[...]
> SELECT codon, sum(nexamples)
> FROM summary
> WHERE expl = 'f'
> GROUP BY codon
> HAVING expl = 'f';
OK! As I thought, I was being thick - helps to read the book properly instead
of dipping into it. Thanks Tom for clearing this up!
Andrew
--
Dr. Andrew C.R. Martin EMail: a.c.r.martin@reading.ac.uk (work)
Lecturer in Bioinformatics andrew@stagleys.demon.co.uk (home)
University of Reading
Tel.: +44 (0)118 987 5123x7022 Fax: +44 (0)118 931 0180