Skip site navigation (1) Skip section navigation (2)

SELECT DISTINCT and count(1)

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SELECT DISTINCT and count(1)
Date: 2009-07-16 09:57:56
Message-ID: dbbf25900907160257n3f0e5782v80ba8e1d8585df68@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi.
I need to do a

select distinct userid  from  usertable,<more tables>  where <conditions>;

and then count the rows in the result

How do I do that?

Responses

pgsql-novice by date

Next:From: A BDate: 2009-07-16 10:16:32
Subject: Re: SELECT DISTINCT and count(1)
Previous:From: Crystal BEWZADate: 2009-07-15 17:47:11
Subject: Re: Where to find libpq.lib? Or How to link to libpq using windows VS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group