G. Anthony Reina writes:
> It's interesting that "select target, avg(reaction_time) from data_table
> GROUP BY target;" works but not "select target, avg(reaction_time) from
> data_table;".
>
> Doesn't the parser automatically group by the first variable returned?
The parser really doesn't know
Try :
select target, avg(reaction_time) from data_table group by target;
Haven't tested it, but it should be close to what you're looking for.
At 02:14 PM 3/3/00, G. Anthony Reina wrote:
>I'd like to return an average for one item in my database grouped by
>another item. For example,
>
>The tab
