Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.11.0) with ESMTP id e9JIK6n76932 for ; Thu, 19 Oct 2000 14:20:07 -0400 (EDT) (envelope-from jliang@ipinc.com) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id LAA17529; Thu, 19 Oct 2000 11:19:21 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39EF39E5.383E0DE4@ipinc.com> Date: Thu, 19 Oct 2000 11:13:57 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: craig.may@s2.enthdimension.com.au CC: pgsql-sql@postgresql.org Subject: Re: COUNT References: <20000906202707.A4767@s2.enthdimension.com.au> <20001020045843.A6717@s2.enthdimension.com.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/181 X-Sequence-Number: 1843 Hi, there, You want how many rows in your table??? select count(*) from yourtablename; Craig May wrote: > Hi, > > How do I get a row count, like "Select [COUNT] from Table" ?? > > Regards, > Craig May > > Enth Dimension > http://www.enthdimension.com.au -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com