8 Replies Latest reply: Jul 17, 2015 7:18 AM by rohit gharat RSS

    Distinct Count

      ACT_DATEMARALT_ACTN_USER_ID
      2-Jun-15150529SCBLMYKXBLAB08641921341487822
      2-Jun-15150529SCBLMYKXBLAB08641921341487822
      2-Jun-15150529SCBLMYKXBLAB08641921341487822
      2-Jun-15150529SCBLMYKXBLAB08641921341487822
      2-Jun-15150529SCBLMYKXBLAB08641921341487822
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487821
      3-Jun-15150603SCBLMYKXALAB01298752131487823
      3-Jun-15150603SCBLMYKXALAB01298752131487823
      3-Jun-15150603SCBLMYKXALAB01298752131487823
      3-Jun-15150603SCBLMYKXALAB01298752131487823
      3-Jun-15150603SCBLMYKXALAB01298752131487823
      3-Jun-15150603SCBLMYKXALAB01298752131487823
      3-Jun-15150603SCBLMYKXBLAB08651988471487823
      4-Jun-15150604SCBLMYKXXLAB04037026551487823
      4-Jun-15150604SCBLMYKXALAB01298769381487823
      4-Jun-15150604SCBLMYKXALAB01298769381487823
      4-Jun-15150604SCBLMYKXALAB01298769381487823
      2-Jun-15150529SCBLMYKXBLAB086419213551487822
      2-Jun-15150529SCBLMYKXBLAB086419213551487822
      2-Jun-15150529SCBLMYKXBLAB086419213551487822
      2-Jun-15150529SCBLMYKXBLAB086419213551487822
      2-Jun-15150529SCBLMYKXBLAB086419213551487822
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-15150529SCBLMYKXBLAB0864191487821
      3-Jun-151AB086419213551487823
      3-Jun-151AB086419213551487823
      3-Jun-151AB086419213551487823
      3-Jun-151AB086419213551487823
      3-Jun-151AB086419213551487823
      3-Jun-151AB086419213551487823
      3-Jun-151AB086419213551487823
      4-Jun-151AB086419213551487823
      4-Jun-151AB086419213551487823
      4-Jun-151AB086419213551487823
      4-Jun-151AB086419213551487823

       

      In the above table    ,

       

      Need to find for given ALT_ACTION_USRID , count of Unique mar greater than 2