0 Replies Latest reply: Jun 9, 2015 8:54 AM by Young Ji RSS

    Plz show me the way to find out the data.

      These are the sample bank transaction data.

       

      transaction id               account        amount             transaction time(hhmmss)

      ------------------               -----------       ----------             ----------------------

          aaa                                a                100                 000100

          aab                                a                200                 000130

          aac                                a                100                 000200

          aad                                a                300                 000230

          aae                                a                200                 003000

          aaf                                 a                400                 000145

          bba                                b                100                 010000

          bbb                                b                200                 010030

          bbc                                b                300                 010510

          bbd                                b                300                 010520

       

      I would like to select the RECORD or # OF TRANSACTION done by ONE account with following conditions.

      1) transaction amount is 100~300 and

      2) the # of transaction is more than or equal to 3 and

      3) these transactions have occured within 5 minutes.

      the answer of transaction id would be aaa,aab,aac,aad, bba,bbb,bbc,bbd.

       

      I would be very habby to get the expression of the condition.

      Thank you