Re: How can i get distinct records with a minimum value

Thanks a lot Michel "Colombo" ;-)

Wish you a nice day as well.
Miguel

On Wed, 27 Oct 1999 09:22:40 +0200, "Michel Cadot"

>just remove status from your group by clause:
>select ... group by req_cod, sub_req;
>

>Miguel Nunes Pinto a écrit dans le message :

>> In a SQL query i need to get the records wich have a distinct
>> combination of two fields (REQ_COD/SUB_REQ in the example), and at the
>> same time the records on wich another field (STATUS) has the minimum
>> value. I need to have a where clause as well.
Received on Wed Oct 27 1999 - 06:27:19 CDT