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.