2 Replies Latest reply on Aug 5, 2013 2:13 AM by alexandr nagovicyn

    How to calculate the last recorded value?

    alexandr nagovicyn

      HI there.

      I've got some data about social media and social networks accounts. This data is writing to database by software 1 time for each 2-4 hours.

      It is split by type of measure: comments, posts, likes, dislikes etc.

       

      I need to get last recorded value in my table by ID and type.

       

      The result must be like this:

      IDTypeValue
      7commentslast value
      7postslast value
      8likeslast value
      ...

       

      I thinking about it for 2 days and i can't sleep because it must be simple but i don't get it(

       

      Pls help)