How to remove distinct rows using sql query? : I have a table which is as follows:

    cust_name   cust_address  sex  orderactive
    xxxx        yyy            m    1
    iiii        iii            f    1
    xxxx        yyy            m    1

I want to keep the duplicate entries and remove unique one's and my resultant table (after removing the duplicates) should look like -

    cust_name   cust_address  sex  orderactive
    xxxx        yyy            m    1
    xxxx        yyy            m    1

Any clues or help would be appreciated.
