Here is the current output for my select statement. I would like it to return one row for this jobsubmissionid, where it selects only the non-zero value from each of the rows. I tried using
SELECT DISTINCT jobsubmissionidbut it still returned 5 rows.
