Re: Count Issues

Поиск
Список
Период
Сортировка
Искать
От
Andre Maasikas
Тема
Re: Count Issues
Дата
Msg-id
416EE980.2060701@abs.ee
Ответ на
Список
Дерево обсуждения
Count Issues Dev <dev@umpa-us.com>
Re: Count Issues Steven Klassen <sklassen@commandprompt.com>
Re: Count Issues Andre Maasikas <andre.maasikas@abs.ee>
Re: Count Issues John Sidney-Woollett <johnsw@wardbrook.com>
R: Count Issues "Luciano Bastianello " <lucianobastianello@yahoo.it>
Re: Count Issues Dev <dev@umpa-us.com>
Dev wrote:

> Hello all,
> 
> I am trying to get a total number of rows returned form a query.
> 
> SELECT count(this) from table group by this
> 
> Currently it is returning x rows  with a count of each of the group by.
> 
> I need the count of the rows returned!
> 
SELECT COUNT(DISTINCT this) FROM table

Andre
В списке pgsql-general по дате отправления
От: Thomas F.O'Connell
Дата:
Сообщение: Re: Boolean
От: Steven Klassen
Дата:
Сообщение: Re: Count Issues
FAQ