Postgres Pro
Downloads
Home   >   mailing lists

SELECT DISTINCT and count(1) - Mailing list pgsql-novice

From A B
Subject SELECT DISTINCT and count(1)
Date
Msg-id dbbf25900907160257n3f0e5782v80ba8e1d8585df68@mail.gmail.com
Whole thread Raw
Responses Re: SELECT DISTINCT and count(1)  (nobs@nobswolf.info (Emil Obermayr))
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: "Crystal BEWZA"
Date:
Subject: Re: Where to find libpq.lib? Or How to link to libpq using windows VS
Next
From: A B
Date:
Subject: Re: SELECT DISTINCT and count(1)