Difference between count(1) and count(*)

From: Mukund <mukundan.a_at_piramyd.co.in>
Date: Thu, 8 Jul 2004 11:27:28 +0530
Message-ID: <005201c464b0$731404d0$1a221ec7@mukundan>

Dear All,
Can you let me know the difference between count(*) and count(1) ?

Warm Regards,
Mukund

---

CONFIDENTIALITY CAUTION
This communication (including any accompanying documents) is intended only for the use of the addressee(s) and contains information that is PRIVILEGED AND CONFIDENTIAL. Unauthorized reading, dissemination, distribution or copying of this communication is prohibited. If you have received this communication in error, please notify us immediately by telephone (91-22) 24927039 or email at administrator_at_piramyd.co.in and promptly destroy the original communication. Thank you for your cooperation.

Communicating through email is not secure and capable of interception, corruption and delays. Anyone communicating with Piramyd by email accepts the risks involved and their consequences.

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jul 08 2004 - 00:58:41 CDT