Illegal use of aggregates or non-group column in target list
| От | G. Anthony Reina |
|---|---|
| Тема | Illegal use of aggregates or non-group column in target list |
| Дата | |
| Msg-id | 38C00122.F382048C@nsi.edu обсуждение исходный текст |
| Ответы |
Re: [GENERAL] Illegal use of aggregates or non-group column in
target list
|
| Список | pgsql-general |
I'd like to return an average for one item in my database grouped by
another item. For example,
The table looks like this:
=================
CREATE TABLE data_table (
subject text,
arm char,
target int4, -- end of primary
key
reaction_time float4
);
CREATE UNIQUE INDEX pkdata_table ON data_table (subject, arm, target);
The command I'd like to use is something like:
================================
select target, avg(reaction_time) from data_table;
and I'd like this command to return:
target | avg
=============
1 | 301.3
2 | 311.45
3 | 299.1
4 | 300.8
However, this statement just gives me the error: Illegal use of
aggregates or non-group column in target list.
So apparently I can only return either one or the other but not the two
together. Is there a way to get the output I want in SQL?
Thanks.
-Tony
В списке pgsql-general по дате отправления: