1 Reply Latest reply: Apr 17, 2013 1:20 PM by Gysbert Wassenaar RSS

    Help : nobody has found a solution ? Aggregated functions

    Ankri Laurent

      Hi

       

      I have a table with the values above :

       

      PRESCRIPTEUR_NUM          DATE_PREVISION               REALISATOR

      12523                                   04/09/2012                              karine

      12523                                   06/09/2012                              paul

      12524                                   04/10/2012                              lea

      12525                                   05/10/2012                              karine

      12525                                   05/10/2011                              karine

      12526                                   01/11/2011                              fred

       

      I want to find, in a chart, the Realisator for the max of the date for each PRESCRIPTEUR_NUM

       

      In the example, I want to find :

      PRESCRIPTEUR_NUM          DATE_PREVISION               REALISATOR

      12523                                   06/09/2012                              paul

      12524                                   04/10/2012                            lea

      12525                                   05/10/2012                              karine

      12526                                   01/11/2011                              fred    

       

      Attached my document

       

      Thanks a lot