SQL problem with aggregate functions.

Поиск
Список
Период
Сортировка
От David BOURIAUD
Тема SQL problem with aggregate functions.
Дата
Msg-id 200207091036.17913.david.bouriaud@ac-rouen.fr
обсуждение исходный текст
Ответы Re: SQL problem with aggregate functions.
Re: SQL problem with aggregate functions.
Список pgsql-sql
Hi the list !
I've got a table in which there is a field that can have one amongst 3 
possible values : D, R, X. Is it possible to get in one query the count of 
this different values.Please, note that I don't want to have a querry like 
this :
"select count (*) from tab group by f1;", cause i want to get all the possible 
count values in one row (these data are already grouped on another field).
To give a more accurate example, here is what I want to retrieve :

Field group | count of D | count of R | count of X.

Any clues ?
-- 
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have 
for windows or gates ?
----------------------------------------------------------
ICQ#102562021





В списке pgsql-sql по дате отправления:

Предыдущее
От: Joseph Syjuco
Дата:
Сообщение: export plpgsql function to file
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: newbie question