4 Replies Latest reply: Jan 27, 2016 5:11 AM by Tamil Nagaraj RSS

    Select only one first value for every id

    Андрей Шепель

      Good day!

       

      I have source table:

        

      CityValue
      City1a
      City1b
      City1c
      City2by
      City2d
      City3zc
      City3s

       

      I need to get result table, which will have only one firts value for every City:

       

        

      CityValue
      City1a
      City2by
      City3zc