SQL riddle !

From: olivier ALLAIN <oallain_at_celya.fr>
Date: Fri, 07 Apr 2000 19:08:45 +0200
Message-ID: <38EE161D.62FF2B51@celya.fr>

I have a table which looks like this :

NUM_CONTACT DATE_CRE NUM_PROJECT
----------- -------- -----------
          1 05/04/00           1
          2 06/04/00           1
          3 07/04/00           2

and i want to know the num_contact of the oldest contact of each project.

Of course, i can't do that :
select min(date_cre),num_contact from contacts group by num_project;

Is thereanyone who can help me ?

Thanx

Oli ALLAIN Received on Fri Apr 07 2000 - 12:08:45 CDT