Best way to get one row back per ID? Select Distinct is not working.

[dshao]

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 jobsubmissionid

but it still returned 5 rows.

[UmaMahesh1 · Accepted solution]

Is that the complete query you are using. I'm guessing that you are using select distinct * from table_name.

If you wanted a individual column distinct value you have to apply a filter condition or aggregate the data accordingly.

Anyways, a complete pic with the query would help to check out what you are doing..

Cheers.

[dshao]

That helped. I was using too many columns in the

GROUP BY

Once I removed all columns except for jobsubmissionid, it returned 1 row.