SQL两个字段去重selecto.name,substr(translate(translate(translate(pa.name,'','|'),'',X'0D'),'',X'0A'),1,254),\translate(c2.fstname,'','|'),\translate(c2.lastname,'','|'),\c2.emailaddr,\translate(coalesce(sao.country,'NULL'),'','|'),\transla

Question

SQL 两个字段去重
select o.name,substr(translate(translate(translate(pa.name,'','|'),'',X'0D'),'',X'0A'),1,254),\
translate(c2.fst_name,'','|'),\
translate(c2.last_name,'','|'),\
c2.email_addr,\
translate(coalesce(sao.country,'NULL'),'','|'),\
translate(coalesce(sao.state,'NULL'),'','|') \
from siebel.eim_opty eo \
join siebel.s_opty o on eo.t_opty__rid = o.row_id \
join siebel.s_postn p on o.pr_postn_id = p.row_id \
join siebel.s_org_ext a on o.pr_dept_ou_id = a.row_id \
left outer join siebel.s_org_ext pa on p.ou_id = pa.row_id \
left outer join siebel.s_addr_org sao on pa.pr_addr_id = sao.row_id \
left outer join siebel.s_postn p2 on p.ou_id = p2.ou_id \
left outer join siebel.s_contact c2 on p2.pr_emp_id = c2.row_id \
where o.x_opty_accept_stat = 'Pending Acceptance' and p2.x_bpoptyfoc_flg = 'Y' and p2.X_PR_BPOPTYFOC_FLG = 'N' and p2.row_id p.row_id \
and o.x_owning_org_id = pa.row_id \
and eo.if_row_batch_num between 104780000 and 104789999 \
and eo.if_row_stat in ('IMPORTED','PARTIALLY_IMPORTED','DUP_RECORD_EXISTS') \
and sao.country = 'JP' \
order by o.name,pa.ou_num with ur
这段SQL希望可以只获取o.name和 c2.email_addr唯一的结果 输出格式要和原来的一样
o.name和c2.email_addr都重复了才算作一条重复记录 单独o.name或者c2.email_addr重复不需要去掉

Answer 1

有个关键字可用
distinct
select distinct name from user
查询不重复的名字