5 Replies Latest reply: Dec 7, 2013 6:01 AM by KOUENS HUGUES RSS

    Expression count()

      Hello everyone!
      I need help, I have a simple table object that displays me

       

      NameUsernaneServiceMonthshours
      a1patcommunication110:30
      a1patcommunication211:11
      a1patcommunication109:00
      b1julcommunication115:00
      b1julcommunication105:45
      c2kou1207:30
      bolsalcommunication807:50

       

      My problem is that want create another expression that counts the number of times the name appears.


      sql I should have something like:


      Select Count(*) from mychart GROUP BY (Name,Username,Months,Service)