4 Replies Latest reply: Oct 21, 2015 4:04 AM by Aswin raaj RSS

    consider the following scenario:

    sumit jadhav

      ticket no                     date

      1                               1/1/2015

      2                               2/1/2015

      3                              3/1/2015

      3                             4/1/2015

      4                            5/1/2015 

      5                            6/1/2015

      5                           7/1/2015

      6                          8/1/2015

       

       

       

      output must be:

       

      ticket no                     date

      1                               1/1/2015

      2                               2/1/2015

      3                             4/1/2015

      4                            5/1/2015 

      5                           7/1/2015

      6                          8/1/2015

       

      how to do it if we apply coun and distinct funjction the output must be same....