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 is also some fun

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

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

[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

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

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 Oct 2001 11:41:11 -0800 i think