RE: Diff Between Count( * ) and Count( 1 )

RE: Diff Between Count( * ) and Count( 1 )

 

  

I think one has a *, and the other has a 1.


Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]

-----Original Message-----
From: Israel Laureano Lazcano [mailto:oracledba-ezmlmshield-x8416304.[Email address protected]
Sent: Friday, June 29, 2007 2:13 PM
To: LazyDBA Discussion
Subject: Re: Diff Between Count( * ) and Count( 1 )

As far as I know, there's no difference.

dgaikwad escribió:

>Hi DBA's
>
>Can anyone tell me Which is to use COUNT(*) or COUNT(1) and Why?
>
>What is exact Difference between them?
>
>
>
>Thanks & Regards,
>Dinesh G.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page