Retreving count of rows returned by a join query

Поиск
Список
Период
Сортировка
Искать
От
Jasbinder Singh Bali
Тема
Retreving count of rows returned by a join query
Дата
в 05:32:35
Msg-id
a47902760705310132w3c08030am63be8b5db4a24d90@mail.gmail.com
Список
Дерево обсуждения
Retreving count of rows returned by a join query "Jasbinder Singh Bali" <jsbali@gmail.com>
Re: Retreving count of rows returned by a join query "Phillip Smith" <phillip.smith@weatherbeeta.com.au>
Re: Retreving count of rows returned by a join query "Jasbinder Singh Bali" <jsbali@gmail.com>
Re: Retreving count of rows returned by a join query "Phillip Smith" <phillip.smith@weatherbeeta.com.au>
Re: Retreving count of rows returned by a join query Sean Davis <sdavis2@mail.nih.gov>
Re: Retreving count of rows returned by a join query David Gardner <David.Gardner@yucaipaco.com>
I have a query in which I have joins.

something like

select a.1, b.2 from a, b
where a.3 = b.3;

how can I fetch the number of rows returned by this query.
normal count(*) doesn't work in this context as desired.

Thanks,
~Jas
В списке pgsql-novice по дате отправления
От: Phillip Smith
Дата:
FAQ