sql - DISTINCT to only one column -

sql - DISTINCT to only one column -

i'm using query , attempting modify returns distinct "lodnum" there on 2 entries of said "lodnum".

i've looked row_number() on / partitions. cannot seem want.

the query is: (sorry formatting)

select i.lodnum, i.prtnum, i.lotnum, sum(i.untqty), i.ftpcod, i.invsts inventory_view i, locmst m i.stoloc = m.stoloc , m.arecod = 'part-hsy' , i.prtnum not in (select i2.prtnum inventory_view i2, locmst m2 i2.stoloc = m2.stoloc , m2.arecod = 'part-hsy' , i2.lotnum = i.lotnum , i2.invsts = i.invsts grouping i2.prtnum having count(*) = 1) , i.lodnum in (select i3.lodnum inventory_view i3, locmst m3 i3.stoloc = m3.stoloc , m3.arecod = 'part-hsy' , i3.lotnum = i.lotnum , i3.invsts = i.invsts grouping i3.lodnum having count(*) > 1) grouping i.lodnum, i.stoloc, i.prtnum, i.lotnum, i.ftpcod, i.invsts order i.prtnum, i.lotnum, i.invsts

it like:

with t ( query here without order ) select t.* (select t.*, row_number() on (partition lodnum order lodnum) seqnum t ) t seqnum = 1 order prtnum, lotnum, invsts;

sql distinct