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 по дате отправления: