Re: COUNT

From: <bmccoy(at)chapelperilous(dot)net>
To: Craig May <craig(dot)may(at)s2(dot)enthdimension(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: COUNT
Date: 2000-10-19 18:35:45
Message-ID: Pine.LNX.4.10.10010191429100.16238-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 20 Oct 2000, Craig May wrote:

> How do I get a row count, like "Select [COUNT] from Table" ??

SELECT COUNT(*) FROM <table> <where clause>

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Man's reach must exceed his grasp, for why else the heavens?

In response to

  • COUNT at 2000-10-20 04:58:43 from Craig May

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Richards 2000-10-19 21:01:50 Conditional query plans.
Previous Message Daniel Wickstrom 2000-10-19 18:30:21 Re: COUNT