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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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

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-2017 The PostgreSQL Global Development Group