D
DaBlue
Guest
I want to get only the top row for each user and in some cases there are 3. I've got it limited down to only a few rows if there are duplicates and unfortunately there is no further "data way" to limit the results.
A sample query is:
SELECT
"PUB"."EMPLOYEE"."FirstName",
"PUB"."EMPLOYEE"."LastName",
"PUB"."EMPLOYEE"."IDNum"
FROM "PUB"."EMPLOYEE"
WHERE "PUB"."EMPLOYEE"."ENDEMPLOY" is null
These people may have multiple employment records.
In MSSQL I would do a MAX() but I don't see that as an option in openedge? How can I limit each row to 1 of a unique IDNum?
Continue reading...
A sample query is:
SELECT
"PUB"."EMPLOYEE"."FirstName",
"PUB"."EMPLOYEE"."LastName",
"PUB"."EMPLOYEE"."IDNum"
FROM "PUB"."EMPLOYEE"
WHERE "PUB"."EMPLOYEE"."ENDEMPLOY" is null
These people may have multiple employment records.
In MSSQL I would do a MAX() but I don't see that as an option in openedge? How can I limit each row to 1 of a unique IDNum?
Continue reading...