Printer FriendlyEmail Article Link

How do i use the DISTINCT option in my Informix SQL commands

Answer

As you know, the "DISTINCT" option in SQL will allow you to show only a single result when multiple results exists.

select distinct sftwr_ver from network_entity where class = "TITAN" order by 1;
sftwr_ver
    FP5.1.0
    FP6.0.0
    FP7.0.1
    FP9.0.0
    PARSE FAILED
 


Product : Informix