[Stackoverflow] [Progress OpenEdge ABL] SQL Distinct on First Column OpenQuery

[Michael]

I'm using an OpenQuery in MS SQL Server 2014 to retrieve data from Progress.

This is my query:

SELECT *
FROM OPENQUERY(PRG, 'SELECT "cde","dsc" FROM tblCodes')


And it retrieves data like this:

cde dsc
=== =====
one test
one another
one value
two goes
two here
two also
three example


However, I need to have results look like this:

cde dsc
=== =====
one test
two goes
three example


How do I do this in an OpenQuery?

Continue reading...