COUNT(*) with UNIQUE keyword

Posted in 1995

adel@q8petroleum.com.kw — Thu, 28 Dec 95 12:01:51 GMT — source: Informix-list mailing list archive (1991-1998)

Hi INFORMIX' er if I have this kind of table cartype MERC FORD MERC MERC MERC FORD select COUNT(*) = 6 select UNIQUE cartype = MERC FORD how would I count howmany cartype(S) that I have ...... (i.e. 2) in 1 select statement...???? thanks......