Suppose that I have SQL:
Select DISTINCT co_num, due_date
From coitem
where [some condition here]
Here the code will return DISTINCT values. For example if co_num 123 has 5 lines with same due date, then I will get only one row.
How can we achieve DISTINCT feature in IDO Collection?
Is there a way that I can specify that I want to pull only the distinct rows and not duplicates?
Even in Dataview, is there a way to fetch distinct data?
I know this is something very common in data word. But perhaps I am missing something.
Hi, you need to join the table coitem back on itself, joining on the distinct columns and only return the record with the lowest, or highest, primary key value. Assuming you have a primary key (unique…