Distinct values from an IDO

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.

Parents Reply Children