Archives of the TeradataForum

Message Posted: Tue, 07 Jun 2005 @ 15:49:53 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, June 07, 2005 11:42 -->

How will I get the count of a distinct set of rows without using a derived table

Something like:

     Select count(distinct col1, col2 ...) from ...
     Where ...

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>