Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
228 Posts
ACCEPTED ANSWER

Pinned topic How to perform distinct on a column???

‏2008-10-22T06:00:09Z |
Im currently using IDS 10.0 on a RedHat 9 server and I want to use distinct on a column and not distinctrow.

select distinct C.ID,C.NOM,T.TEL
from client C, tel_client T
where C.ID = T.ID

When I do the same query in MS access everything goes well and Ive got distinct on a column but it seems that informix does not do a distinction between distinct and distinctrow.

Thank you.