Finding records that a negative number with a corresponding positive number

• Briceston

  SSCrazy

  Points: 2899

  More actions

  September 6, 2019 at 9:01 pm

  #3678097

  Hello Gents,

  I have a table that consists of a column that has both negative and positive transaction dollars. I need to identify all duplicate records, that have a negative dollar amount followed by a non-negative dollar amount. I need capture any negative then positive dollar amount regardless if the dollar amounts are the same or different.

  Below are the sample records in the table.

  AccountNumberTxnAmountTransactionDate
  39593546-10836.686/15/2015
  3959354611244.689/24/2015
  00042495-836.68        4/13/2015
  00042495756.01        4/16/2015
  00041475-20936.784/13/2015
  0004147510936.784/13/2015
  00081479       -30436.784/26/2018
  0008147930436.784/26/2018
  

   

   

  Thanks in advance for your help

• drew.allen

  SSC Guru

  Points: 77004

  More actions

  September 6, 2019 at 9:41 pm

  #3678134

  Duplicate post.  Please respond to this one

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• pietlinden

  SSC Guru

  Points: 63535

  More actions

  September 6, 2019 at 9:45 pm

  #3678136

  What's your expected result? What constitutes a "duplicate"? Two records that cancel each other out, like the last pair do?