Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Suresh Maganti Eliminating Duplicate Rows using The PARTITION BY clause RE: Eliminating Duplicate Rows using The PARTITION BY clause

  • June 1, 2012 at 5:41 am

    #1495807

    prakashp 84206 (6/1/2012)

    Hi,

    The output of my query contains duplicate records (i.e. column1 value is similar but other column's value different) as well as single record having column2 value blanks(-). now I want to select only one record out of duplicate records for which column2 values are present (eliminating records for which column2 is blanks(-) from duplicate records) and all other single records having column2 values blanks.

    My query's Present Output

    column1 column2 column3

    abc xyz pqr

    abc - klm

    ijk - uvw

    plo - ujn

    yhk ttg wea

    yhk - erf

    Expected Output

    column1 column2 column3

    abc xyz pqr

    ijk - uvw

    plo - ujn

    yhk ttg wea

    Can someone help me. Thanks in advance.

    Welcome aboard.

    Read the link in my sig, this will assist you in describing your problem and encouraging others to help. Then start a new thread. It's likely that your problem is sufficiently different to the original on this thread that it's better separated from it.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden