3 Replies Latest reply: Nov 26, 2012 5:04 AM by Marco De RSS

    table with max value

      Hi all,
      I need help. I have this table:
      IDSub IDPrice
      11111,8
      1121,4
      1132,3
      22221,7
      2233,4
      2241,2
      And I want to create a table that visualize only the Sub ID with the max price. Eg:
      IDSub IDPrice
      11132,3
      22233,4

       

      How can I obtain this table?

       

      Thanks all.