No.
It just acts like a literal, and oracle counts the occurance of the literal for each row of the table.
rgds
amar
-----Original Message-----
From: dist cash [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: [Q] what difference between count(0), count(1) and
Does count(0) , 0 mean first column and 1 mean second column?
Thanks.
>From: "Arn Klammer" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: [Q] what difference between count(0), count(1) and
>Date: Wed, 24 Oct 2001 18:40:18 -0800
>
>As I understand it, count(*) counts all rows. Anything other than "*" is
>treated as an expression and it returns the number of rows where that
>expression evaluates to not null. So what Deepak said below about
>count(col1) giving the count of non-null instances of col1 is correct.
>That also means that count(0), count(1), etc should behave the same as
>count(*), as 0, 1, etc are not null.
>
>Now, is count(*) less efficient in execution than count(1)? I've been
>asked this before, and I don't know. I would've thought count(*) and
>count(1) would be the same, execution-wise. Is this correct?
>
>-a
>
> >>> [EMAIL PROTECTED] 25/10/2001 11:30:17 >>>
>This message has been scanned by MAILSweeper.
>************************************************************
>
>Thank you for answer. How about count(0)?
>
>
> >From: Deepak Thapliyal <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: [Q] what difference between count(0), count(1) and count(*)
> >Date: Wed, 24 Oct 2001 11:41:11 -0800
> >
> >i think count(*) gives count of all columns .. where
> >as count(col1) gives count for col1 ignoring nulls in
> >col1
> >
> >Deepak
> >--- aaa aaa <[EMAIL PROTECTED]> wrote:
> > > Can anyone tell me what is difference between :
> > >
> > > select count(*) ... from ..
> > >
> > > select count(0) ...
> > >
> > > select coun (1) ...
> > > select count(2) ...
> > >
> > >
> > > Thanks.
> > >
> > >
> > >
> >_________________________________________________________________
> > > Get your FREE download of MSN Explorer at
> > > http://explorer.msn.com/intl.asp
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: aaa aaa
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> >--------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Make a great connection at Yahoo! Personals.
> >http://personals.yahoo.com
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Deepak Thapliyal
> > INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>-
> -
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: dist cash
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>
>This footnote also confirms that this email message has been swept by
>MIMEsweeper for the presence of computer viruses.
>
>www.mimesweeper.com
>**********************************************************************
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Arn Klammer
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: dist cash
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).