Re: COUNT(*) with UNIQUE keyword
How about:
select count(unique cartype) from .......
or did I miss something.
--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523,
USofA; 970-491-1244 FAX 970-491-1205 cwoodall@vth1.vth.colostate.edu
--
On Thu, 28 Dec 1995 adel@q8petroleum.com.kw wrote:
} 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......
}