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