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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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