6 Replies Latest reply on Oct 18, 2010 4:34 PM by thinkingeye

    Need help with max

    thinkingeye
      Hi All
      I have the following data set
      site_id     ref_site_id
      97019011     123398
      97019011     123407
      97019011     143382
      97019011     823
      97019011     1138
      97019011     144002
           
      97019013     1139
      97019013     824
      97019013     144003
      97019013     123408
      97019013     123399
      97019013     143383
      Every site id has multiple ref_site_id's and i just want to load the max(ref_site_id) and i used a filter and tried to use the max function and it wouldnt allow me do it, then i tried using the expression editor with no result either. Can anyone please tell me what operator to use to load the max ref_site_id?

      Thanks