SQL-如何不获取重复值 [英] SQL- how not to get duplicate values

问题描述

有人可以帮我做我的代码吗?我得到多个重复的值.我尝试了分组依据"，但它给了我错误消息.

谢谢

以下是查询

Hi,

Can somebody help me with my code? I am getting multiple duplicate values. I tried "group by", but it gives me error message.

Thanks

Following is the query

SELECT top 10
a.IGFACNAM1 as Name,
a.IGFID# as Id_Num,
a.IGFIDTYP as Id_Type,
a.IGFCIF# as Cif_No,
a.IGFAC# as Acc_No,
c.Occp_Nm1 as Occupation,
a.IGAPPIBCD as Income_Level,-- as Income_Level ?
a.IGMSGID + ''- ''+ a.IGPDTL1 as Trascation_Code_BDS,
a.IGVALDT as Transaction_Date,
count(*) TotalCount,
a.IGTAMT as Transaction_Amount,
--count daily transaction ?
--count(a.IGFAC#) as Daily_Transaction,
a.IGFRMMBR + ''-'' + h.Branch_NM1 as Transaction_Branch,
e.ResdFG_Nm as Resident,
a.IGTOMBR as Beneficiary_Bank,
f.State_NM1 as State,
g.Risk_NM1 as AML_CFT_Risk_Level
from [DW_EDM_BPM].[dbo].[IBG] a
left outer join [DW_EDM_BPM].[dbo].[m4cus] b on
a.IGFACNAM1 = b.Cus_NM1
left outer join [DW_EDM_BPM].[dbo].[pOccp] c on
b.Occp_ID = c.Occp_ID
left outer join  [DW_EDM_BPM].[dbo].[qResd] e on
b.Resd_FG = e.Resd_FG
left outer join [DW_EDM_BPM].[dbo].[pState] f on
b.State_ID = f.State_ID
left outer join [DW_EDM_BPM].[dbo].[pRisk] g on
b.Risk_ID = g.Risk_ID
left outer join [DW_EDM_BPM].[dbo].[pBranch] h on
cast(b.Branch_ID as varchar)  = h.Branch_ID
where a.IGTAMT >= 50000

推荐答案

使用 DISTINCT [ ^ ]语句以删除重复项.

Use DISTINCT[^] statement to remove duplicates.

这篇关于SQL-如何不获取重复值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！