Error message should have been

Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 171
/

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Friday, January 20, 2006 4:24 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Grouping on a calculation

This works:

SELECT
t.COL_1/100, MIN( t.COL_2 )
FROM
TABLE_1 t
GROUP BY
1

This doesn't:

SELECT
t.COL_1/100, MIN( t.COL_2 )
FROM
TABLE_1 t
GROUP BY
t.COL_1/100

Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 171
(

I can't use the first way, as I need to determine what value of t.COL_1
is associated with the minimum value, and the WHERE clause would contain

t.COL_2 = (SELECT MIN( t.COL_2 ) FROM TABLE_1 t GROUP BY t.COL_1/100)

among other conditionals.


So my question is, why doesn't the second query work, and is there
anything that would solve my requirement of finding out what row had the
minimum value?

Thanks, Rick DeBay


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links