none
deleting the duplicate rows RRS feed

  • Question

  • Hello

    A table t1 consists of the following rows

    T1

    col1                      col2                col3

    a                           a                     a

    a                          b                      c

    a                            b                    d

    a                         b                       c

    a                            b                    d

    The output required after deletion of the two rows  (a - b- c   and a - b - d) is

    col1                     col2                  col3

    a                            a                     a

    a                            b                     c

    a                            b                     d

    Please tell me the delete statement required asap

    regds

    Manoj Gokhale

    Thursday, July 6, 2017 3:10 PM

Answers