Re: COUNT(*) with UNIQUE keyword

Posted in 1995

Nils.Myklebust@ccmail.telemax.no — 29 Dec 1995 15:37:39 GMT — source: Informix-list mailing list archive (1991-1998)

> adel@q8petroleum.com.kw writes: > ...deleted... > how would I count howmany cartype(S) that I have ...... (i.e. 2) > in 1 select statement...???? select count(unique cartype) from tablename Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My opinions are those of my company