MySQL Forums
Forum List  »  Newbie

how to combine three columns and remove duplicates in sql
Posted by: Husnain Commerce
Date: January 28, 2022 06:08PM

I have table with 7 columns where I want to combine three column and want to remove duplicates. Your help will be appreciated.

SELECT warranty_indicator,
account,
date_sold,
COUNT(*) AS CNT
FROM SERIAL_NUMBERS
GROUP BY warranty_indicator,
account,
date_sold
HAVING COUNT(*) > 1;

Options: ReplyQuote


Subject
Written By
Posted
how to combine three columns and remove duplicates in sql
January 28, 2022 06:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.