Re: SQL count question

Posted in 1997

Daniel James — 25 Jul 1997 13:03:06 -0400 — source: Informix-list mailing list archive (1991-1998)

Matt Brickley wrote: > The Informix guide to SQL on pg 7-377 shows this statement: > > select fname,count(*) from customer > group by fname > where count(*) > 1 I'd say somebody made a typo. You can do this with... select fname, count(*) from customer group by fname having count(*) > 1 -- ----------------------------------------------------------------------- Daniel James - Database Administrator djames@statsci.com DAPD Div of MathSoft (formerly StatSci) (206) 283-8802 x284