I have a table domain in Maximo 7 which I only want to return a distinct value. The LISTWHERECLAUSE only allows for the where clause of the select statement. Is it possible to get the domain to return a distinct value? Any examples greatly appreciated. Thanks.
This topic has been locked.
3 replies Latest Post - 2013-10-28T09:37:33Z by sac1987
Pinned topic Return a distinct value from Table Domain
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-01-04T08:10:18Z at 2011-01-04T08:10:18Z by Bunty28
badrimax 270001R4547 PostsACCEPTED ANSWER
Re: Return a distinct value from Table Domain2010-04-14T02:14:13Z in response to jn-taicHi,
Add condition to your where clause like mentioned below
I have taken ALNDOMAIN example
alndomainid = (select max(alndomainid) from alndomain a where a.domainid = alndomain.domainid)
ALNDOMAINID is the uniqueid in the table
let me know if it works