Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    3

    Unanswered: ESQL query issue DISTINCT

    Hello,

    I want to select distinct records from a Master table in db2 DISTINCT works fine but in ESQL is there any thing similar to it

    Thanks in advance

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    at my knowlege, you cannot directly select distinct ( row) from table in Informix.
    A workaround would consist in concatenating all the columns of the table, a bit like this

    Code:
    SELECT DISTINCT (col1||col2||col3||col4...||coln)
    from table
    Caution, this is going to be very heavy is the table is big...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •