title: Select rows that do not have the opposite value in another row
body: <p>I am trying to write a query that will only select rows that does not have the opposite value. For example if a column (payments) has 2 negative numbers(-11) and 3 positive numbers(11) both the negative numbers would cancel out and one positive number will remain. I may be explaining this wrong. But any help is  appreciated.
  table :</p>
  
  <pre><code>CREATE TABLE hamzachecks(
     ID      VARCHAR(2) NOT NULL
    ,CHECK   VARCHAR(10) NOT NULL
    ,Payment VARCHAR(8) NOT NULL
  );
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('1','9549549544','-112.96');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('2','9549549544','-112.96');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('3','9549549544','112.96');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('4','9549549544','112.96');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('5','9549549544','-165.92');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('6','9549549544','225.92');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('7','9549549544','-299.3');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('8','9549549544','-299.3');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('9','9549549544','-299.3');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('10','9549549544','299.3');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('11','9549549544','299.3');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('12','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('13','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('14','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('15','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('16','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('17','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('18','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('19','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('20','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('21','9549549544','-415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('22','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('23','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('24','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('25','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('26','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('27','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('28','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('29','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('30','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('31','9549549544','415.14');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('32','9549549544','-1024.22');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('33','9549549544','1024.22');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('34','9549549578','-253.77');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('35','9549549578','253.77');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('36','9549549578','-3332.16');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('37','9549549578','-6664.29');
  INSERT INTO hamzachecks(ID,CHECK,Payment) VALUES ('38','9549549578','6664.29');
  </code></pre>