Paradox Community

Items in pnews.paradox-dos

Subject:Re: single row query - progress
Date:Wed, 16 May 2018 08:16:01 -0400
From:"Larry DiGiovanni" <nospam@nospam>
Newsgroups:pnews.paradox-dos
Bernie van't Hof wrote:

> CALC count all, calc 3 +2

>  count(DISTINCT `t3`.`Amt`) AS `Count of Amt`,

Is that right?  I thought CALC COUNT ALL counted duplicates.  If so, 
COUNT(DISTINCT does just the opposite.

--
Larry DiGiovanni


Copyright © 2004 thedbcommunity.com