""Louis Kleiman"" <lkleiman@...> wrote in message
news:00b501c1bedc$d69f4810$de0e500a@monster...

> How about using "GROUP BY 1"?

Louis, in Interbase or Firebird???

From the DSQL parser:

group_clause : GROUP BY grp_column_list

grp_column_list :
grp_column_elem
| grp_column_list ',' grp_column_elem

grp_column_elem :
column_name
| udf => Neil's McCalden extension.
| column_name COLLATE symbol_collation_name

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing