>>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().
Sorry Dragan,
but I cannot see the usability of this random aggregate function.