[comp.databases] SQL/QUEL discrepency

pavlov@hscfvax.harvard.edu (G.Pavlov) (03/11/89)

In article <469@agrigene.UUCP>, overby@agrigene.UUCP (Scott Overby) writes:
> 
> 
> What follows are two selects from the same data; one in quel, the other SQL.
> The count aggregate differs among them.  The quel count is the actual number
>  of rows from the 'invoice' table(not what I want).  While the SQL count is 
> what I am really after; the number of rows in 'invoice' that have the same
>  pedigreecode, same invoiceyear, and the same countrycode.  
>    How can I change the quel code to make it behave like SQL?  I absolutely
> need to write it in quel!!!!
> 
  Per the quel manual, selection expressions for aggregates must be put within
  the parens, e.g.,
                   n=count(senator.all where senator.tower_vote="NO")

  greg pavlov, fstrf, amherst, ny