- 5889 Views
- 2 replies
- 0 kudos
Resolved! Best way to get one row back per ID? Select Distinct is not working.
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.
- 5889 Views
- 2 replies
- 0 kudos
Latest Reply
- 0 kudos
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 ...
- 0 kudos