Sql聚合函数错误

问题描述

大家好，





我有选择查询给我错误

请考虑文字标记为粗体，导致此错误。

Hello all,


I have select query which is giving me error
Please consider Text marked in bold which is causing this error.

select ROW_NUMBER() OVER (ORDER BY um.Id) AS [Sr_No],um.DOCRcvdDt as InwardDate, um.ScanId,um.ProposerName as CustomerName,um.RiskStartDt,um.RiskEndDt,um.IntermediaryCode,um.ECNNumber,um.ProposalAmount,Convert(varchar(20),um.DOCRcvdDt)+' '+um.DOCRcvdTime as DOCRcvdDtTime,um.Remarks,bb.BBName as Branch,i.NAME,
	it.[Description] as PaymentMode,r.InstrumentNumber,r.InstrumentDate,r.Amount as InstrumentAmount,a1.dtTime QC1PickedDtTime,ld1.Username as QC1UserId,a2.dtTime QC1DoneDtTime,
	a3.dtTime DEPickedDtTime,a4.dtTime DEDoneDtTime,a5.dtTime QC2PickedDtTime,a6.dtTime QC2DoneDtTime,ld2.Username as DEUserId,ld3.Username as QC2UserId,
	a7.dtTime as PolicyIssuedDtTime,sm.ContactId,sm.ProposalNo,sm.PolicyNo,sm.ReceiptNo,ld4.Username as ScanUserId,count(dm.Id)
	from UploadMaster um
	left Join LoginData ld	on um.EmpId=ld.Id
	left Join BBMaster bb  	on ld.BBId=bb.Id
	left Join IMD i   	on i.[IMD code]=um.IntermediaryCode
	left Join T_Instrument_Type it 	on it.ID=um.PaymentMode
	left Join Receipt r 	on r.TxnId=um.ScanId
	left Join Aging a1      on a1.UpldMstrId=um.Id and a1.Status='QC1 Picked'
	left Join LoginData ld1 on ld1.Id=a1.UpdatedBy
	left Join Aging a2      on a2.UpldMstrId=um.Id and a2.Status='QC1 Accepted'
	left Join Aging a3      on a3.UpldMstrId=um.Id and a3.Status='DE Picked'
	left Join LoginData ld2	on ld2.Id=a3.UpdatedBy
	left Join Aging a4      on a4.UpldMstrId=um.Id and a4.Status='DE Accepted'
	left Join Aging a5      on a5.UpldMstrId=um.Id and a5.Status='QC2 Picked'
	left Join LoginData ld3	on ld3.Id=a5.UpdatedBy
	left Join Aging a6      on a6.UpldMstrId=um.Id and a6.Status='QC2 Accepted'
	left Join Aging a7	on a7.Status='Policy Issued' and a7.UpldMstrId=um.Id
	left Join StatusMaster sm	on sm.TransactionId=um.ScanId
	left Join LoginData ld4	on ld4.Id=um.EmpId
	left Join DiscrepencyMaster dm	on dm.UploadId=um.Id
        group by dm.Id
	order by um.ScanId

错误：

Error :

Column 'UploadMaster.Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

请解释原因这个错误即将来临。

如何排序。



谢谢

问候

SUNIL MALI。

Please explain why this error is coming.
And how to sort it.

Thanks
Regards
SUNIL MALI.

推荐答案

时，它是唯一有意义的

这篇关于Sql聚合函数错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！