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: x <x-false_at_yahoo.com>
Date: Tue, 15 Jun 2004 14:19:12 +0300
Message-ID: <40ceda35$1@post.usenet.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.

Do you think there is a need for a CARDINALITY(<table expression>) operator in addition to COUNT(DISTINCT <exp>) ?

What is the difference between COUNT(*) and COUNT(<exp>) ?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Tue Jun 15 2004 - 06:19:12 CDT

Original text of this message

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