Sorry but I do not understand what you want. My query returns exactly one row per group as you asked. Can you provide some examples?
>Thanks for your suggestion Sergey, but due to values of field2... are in different in rows, the procedure returns more than one row (by group), and I can´t ommit the field2 in group by because query does not permit this.
>
--sb--