从SQL中删除重复项 [英] Removing duplicates from SQL

问题描述

嗨

我有一个查询4个表的SQL查询。结果返回A列中的重复结果，即电子邮件地址。使用下面的SQL查询，如何添加删除重复电子邮件地址的代码？

  SELECT   distinct （cl.RIID_），cl.EMAIL_ADDRESS_，bro.ITEM，bro.ACTIVITY_DATE 
  FROM  $ A $ cl  JOIN  
ro  ON  cl.EMAIL_ADDRESS_ =兄弟.EMAIL_ADDRESS_ 
  JOIN  $ D $ cms  ON  cms.SKU = bro.ITEM 
  WHERE  cl.EMAIL_DELIVERABILITY_STATUS_ = '  D' 
  AND  cl.EMAIL_PERMISSION_STATUS_ = '  I ' 
  AND  cms.BSCATEGORYNAME = '  Toys& Baby' 
  AND （trunc（bro.ACTIVITY_DATE））> =（Trunc（Cast（From_Tz）（Cast（Sysdate 作为 时间戳），'  US / Pacific'）时间区域' 澳大利亚/悉尼' 作为 日期）） -   30 ）

解决方案

A

cl JOIN

乙

Hi
I have a SQL query looking at 4 tables. The results come back with duplicate results in column A which is email address. With the below SQL query, how can I add code that removes duplicate email addresses?

SELECT distinct(cl.RIID_),   cl.EMAIL_ADDRESS_,   bro.ITEM,   bro.ACTIVITY_DATE  
FROM $A$ cl  JOIN $B$ bro ON cl.EMAIL_ADDRESS_ = bro.EMAIL_ADDRESS_   
JOIN $D$ cms ON cms.SKU = bro.ITEM  
WHERE cl.EMAIL_DELIVERABILITY_STATUS_ = 'D'   
AND cl.EMAIL_PERMISSION_STATUS_ = 'I'   
AND cms.BSCATEGORYNAME = 'Toys & Baby'   
AND (trunc(bro.ACTIVITY_DATE)) >= (Trunc(Cast(From_Tz(Cast(Sysdate As Timestamp ), 'US/Pacific') At Time Zone 'Australia/Sydney' As Date)) - 30)

解决方案

A

cl JOIN

B

这篇关于从SQL中删除重复项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！