Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Counting propositions

Re: Counting propositions

From: Laconic2 <laconic2_at_comcast.net>
Date: Tue, 15 Jun 2004 08:00:39 -0400
Message-ID: <nImdncrlS7AQeVPdRVn-ig@comcast.com>

"--CELKO--" <jcelko212_at_earthlink.net> wrote in message news:18c7b3c2.0406141957.29e933ea_at_posting.google.com...
> One problem here is that COUNT(*) is CARDINALITY of the set qua set,
> while COUNT([DISTINCT] <exp>) is at the element level inside the set.
> Maybe we should have made the syntax: "CARDINALITY(<table
> expression>)" so you'd know the level that the operatgor is working
> at.

Speaking of that, I've seen several examples where the writer puts

SELECT COUNT(1) FROM source WHERE (predicate);

I've always wondered whether there are any consequences to that usage, other than readability? Received on Tue Jun 15 2004 - 07:00:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US