计算每人的总面积 [英] calculate total area per person
问题描述
ID OName村落Mahal Mauza SNo KhatuniNo KhasaraNo Area(ha)
2拉金德·辛格·苏拉·巴拉·苏拉2 12 4.43
3拉金德·辛格(Rajinder Singh Sullah)姜格·苏拉(Jangher Sullah)2 19 0.15
4拉金德·辛格(Rajinder Singh Sullah)玛哈克拉(Majhakra Sullah)2155 0.29
5拉金德·辛格(Rajinder Singh Sullah)玛哈克拉(Majhakra Sullah)2157 0.10
6拉金德·辛格·苏拉·巴拉·苏拉2 13 547/88 0.6
7 Swarna Devi Sullah Balla Sullah 3 12 4.43
8 Swarna Devi Sullah Jangher Sullah 3 19 0.15
9 Swarna Devi Sullah Majhakra Sullah 3 155 0.29
10 Swarna Devi Sullah Majhakra Sullah 3 157 0.10
这是我的数据库表,看起来像...我想计算每人的总面积...
ID OName RVillage Mahal Mauza SNo KhatuniNo KhasaraNo Area(ha)
2 Rajinder Singh Sullah Balla Sullah 2 12 4.43
3 Rajinder Singh Sullah Jangher Sullah 2 19 0.15
4 Rajinder Singh Sullah Majhakra Sullah 2 155 0.29
5 Rajinder Singh Sullah Majhakra Sullah 2 157 0.10
6 Rajinder Singh Sullah Balla Sullah 2 13 547/88 0.6
7 Swarna Devi Sullah Balla Sullah 3 12 4.43
8 Swarna Devi Sullah Jangher Sullah 3 19 0.15
9 Swarna Devi Sullah Majhakra Sullah 3 155 0.29
10 Swarna Devi Sullah Majhakra Sullah 3 157 0.10
This is my database table looks like ...I want to calculate the total area(ha)per person...
how to solve it?
推荐答案
由于您没有给我们任何信息,所以您的数据库表中的列是什么意思,也没有提到表的名称,我"会有点在黑暗中摸索":
Since you have not given us any information what the columns in your database table mean and neither have mentioned the table''s name, I''ll be "groping around in the dark" a bit:
SELECT OName, SUM([Area(ha)] AS TotalArea
FROM SomeTableName
GROUP BY OName
如果一个人的名字不只是OName
,则必须调整 GROUPBY [ select语句的 ^ ]子句.
问候,
曼弗雷德(Manfred)
In case the name of a person is not just OName
, you''d have to adjust the GROUPBY[^] clause of the select statement.
Regards,
Manfred
这篇关于计算每人的总面积的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!