Received: from lscorp.com (poohbah.lscorp.com [207.152.64.2]) by hub.org (8.8.8/8.7.5) with ESMTP id WAA15430 for ; Sun, 3 May 1998 22:12:59 -0400 (EDT) Received: from [207.152.64.133] by lscorp.com with SMTP (Eudora Internet Mail Server 1.2); Sun, 3 May 1998 21:10:22 -0500 X-Sender: lynch@poohbah.lscorp.com Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: pgsql-sql@postgresql.org From: lynch@lscorp.com (Richard Lynch) Subject: count and actual data Date: Sun, 3 May 1998 21:10:22 -0500 Okay, it's really something I need to do in Access (don't ask why), but there's no way I'm going to actually join an Access mailing list. :-) select name from users; gives me: name ---- Steve Bill select count(name) from users; gives me: count ----- 2 Now, I really want the result from the first query, *AND* the count from the second query. select name, count(name) from users; would be fine, even if it did give me the count too many times, but it won't work. So. how does one get both the data and the count as results in table format from a query? -- -- -- "TANSTAAFL" Rich lynch@lscorp.com