20 Replies Latest reply: May 20, 2016 8:54 AM by Tamil Nagaraj RSS

    Load only rows with min value

    Hans Müller

      Hi guys,

       

      I'm trying to load "min values" from a table. I have redundant rows but I want only the row's which have the min Amount.

       

      Example:

        ID, Amount

          1, 5

          1, 2

          2, 3

          2, 8

          3, 9

       

      In this Example I want only back...

       

      1,2

      2,3

      3,9

       

      But I don't know to handle this.

       

      Thank you