is -10 earnigns higher than -20 earnings code example

Example: is -10 earnigns higher than -20 earnings

// Queries used for updates to the AUDIT tables
SELECT * FROM GUDA.AUDIT WHERE CHANGED_FIELD = 'STATUS';
SELECT * FROM GUDADEV.AUDIT WHERE CHANGED_FIELD = 'STATUS';
SELECT * FROM GUDATEST.AUDIT WHERE CHANGED_FIELD = 'STATUS';


SELECT * FROM GUDA.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';
SELECT * FROM GUDADEV.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';
SELECT * FROM GUDATEST.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';


UPDATE GUDA.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';
UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';
UPDATE GUDATEST.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';


UPDATE GUDA.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDATEST.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';

UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD IN ('STATUS','DEPT_STATUS');

Tags:

Misc Example