>Then, it needs to extend the language SQL with a declarative clause
>GROUP WITH ORDER ... BY..
>
>example:
>

>* this have not sense because Item2 is out of set
>SELECT Item,First(f1),Last(f2) FROM table GROUP BY Item ORDER BY Item2
>
>* this have sense because WITH ORDER declare the order grouping
>SELECT Item,First(f1),Last(f2) FROM table GROUP WITH ORDER Item2 BY Item
>

Right... what we need is an aggregate function any(), which would mean "the first value you get, I don't care in which order". That one would be fast, and simpler than min() or max().