Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Retreving count of rows returned by a join query
- From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
- To: pgsql-novice(at)postgresql(dot)org
- Cc: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>, "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
- Subject: Re: Retreving count of rows returned by a join query
- Date: Thu, 31 May 2007 06:08:08 -0400
On Thursday 31 May 2007 05:17, Jasbinder Singh Bali wrote: > with count(*) i want other rows as well > something like > > select count(*) , a.3 from a, b where a.3 = b.3; That would require two queries unless you want to use subqueries: select count(*) from a,b where a.3=b.3; select a.3 from a,b where a.3=b.3; Sean
- References:
- Retreving count of rows returned by a join query
- From: Jasbinder Singh Bali
- Re: Retreving count of rows returned by a join query
- From: Phillip Smith
- Re: Retreving count of rows returned by a join query
- From: Jasbinder Singh Bali
- Retreving count of rows returned by a join query
- Prev by Date: Re: Retreving count of rows returned by a join query
- Next by Date: lock row outside transaction, if not ...
- Previous by thread: Re: Retreving count of rows returned by a join query
- Next by thread: lock row outside transaction, if not ...
- Indexes: