Re: [Q] what difference between count(0), count(1) and count(*)

>--- 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) ... For other insights take a look at http://www.oracledba.co.uk/tips/count_speed.htm There

RE: [Q] what difference between count(0), count(1) and count(*)

y-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 co

Re: [Q] what difference between count(0), count(1) and count(*)

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 O

Re: [Q] what difference between count(0), count(1) and count(*)

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) ...

[Q] what difference between count(0), count(1) and count(*)

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.as