>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.
>
>Any other idea?
>
>Thanks
>Carlos Burgos

Hi Carlos,

Do you have multiple records with the same date and you only want to select one of these records?

Can you please post your table script and the result you want?