Re: Count Issues

Поиск
Список
Период
Сортировка
Искать
От
Steven Klassen
Тема
Re: Count Issues
Дата
Msg-id
20041014210305.GA18037@commandprompt.com
Ответ на
Список
Дерево обсуждения
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  [2004-10-14 16:54:56 -0400]:

> I am trying to get a total number of rows returned form a query.
> 
> SELECT count(this) from table group by this

Remove the 'group by' clause -- you don't need it.

-- 
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
В списке pgsql-general по дате отправления
От: Andre Maasikas
Дата:
Сообщение: Re: Count Issues
От: John Sidney-Woollett
Дата:
Сообщение: Re: Count Issues
FAQ