sum varchar如何做列 [英] How do sum varchar column

问题描述

我在表中有2列是



列名数据类型是varchar

列数量是nvarchar



名称金额

Karthikeyan R 11

Karthikeyan R 51

Mohammedhussain TM 19

Mythili V 37

Rangaraj C 145- $ 4358.14



i想要金额兑换name.plz帮助我



我尝试了什么：



我需要在下面重新开始

i have 2 columns in table are

column name datatype is varchar
column Amount is nvarchar

Name Amount
Karthikeyan R 11
Karthikeyan R 51
Mohammedhussain T M 19
Mythili V 37
Rangaraj C 145- $4358.14

i want sum the amount against name.plz help me

What I have tried:

and i need resut below

Name	Amount
Karthikeyan R	62
Mohammedhussain T M	19
Mythili V	37
Rangaraj C	145- $4358.14

推荐答案

4358.14



i想要总和对name.plz的金额帮助我



我有什么ried：



我需要在下面重新开始

4358.14

i want sum the amount against name.plz help me

What I have tried:

and i need resut below

Name	Amount
Karthikeyan R	62
Mohammedhussain T M	19
Mythili V	37
Rangaraj C	145-

4358. 14

不能这样做。你怎么期望总和145 -

No can do. How do you expect to sum 145-

这篇关于sum varchar如何做列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！