5 Replies Latest reply: Jul 2, 2013 5:31 AM by dw_axisoft RSS

    How to group the data base on the client No.

      Currently, we have a table like below:

       

      ID     client No.  Update date

      1      11                6/20/2013   

      2      33               6/20/2013

      3      11               6/21/2013

      4      44               6/21/2013

      5      33               6/21/2013

      6      55               6/22/2013

      7      11               6/22/2013

      8      33               6/22/2013

       

      I want to count that the total updated records/new insert records

       

      e.g. get the total updated records on 6/22/2013

       

      count({1<[Update date] = {'6/22/2013'}, ID = {">$(=min(ID))"}>} ID)

       

       

      the problem is how to get the min id for each client No.?