标题: zhuyiwen近来 [打印本页] 作者: tianshi 时间: 2002-4-13 22:04 标题: zhuyiwen近来 SELECT 奶牛登记卡.所在乡镇, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏之Sum, Sum(奶牛登记卡.可繁) AS 可繁之Sum, Sum(奶牛登记卡.育成) AS 育成之Sum, Sum(奶牛登记卡.泌乳) AS 泌乳之Sum, Sum(奶牛登记卡.犊牛) AS 犊牛之Sum, Sum(奶牛登记卡.青贮窖) AS 青贮窖之Sum, Sum(奶牛登记卡.青贮量) AS 青贮量之Sum, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积之Sum, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量之Sum, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量之Sum
FROM 奶牛登记卡
GROUP BY 奶牛登记卡.所在乡镇
HAVING (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"));
这是个按地址所建立的查询，要查询出10各不同地点的合计数，我的问题是在这个查询中，求出10各地点的总合。包括里面的每一个项目。作者: access91 时间: 2002-4-13 22:45
SELECT 奶牛登记卡.所在乡镇, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏之Sum, Sum(奶牛登记卡.可繁) AS 可繁之Sum, Sum(奶牛登记卡.育成) AS 育成之Sum, Sum(奶牛登记卡.泌乳) AS 泌乳之Sum, Sum(奶牛登记卡.犊牛) AS 犊牛之Sum, Sum(奶牛登记卡.青贮窖) AS 青贮窖之Sum, Sum(奶牛登记卡.青贮量) AS 青贮量之Sum, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积之Sum, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量之Sum, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量之Sum
FROM 奶牛登记卡
GROUP BY 奶牛登记卡.所在乡镇
HAVING (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇")) union
SELECT "heji" as a, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏之Sum, Sum(奶牛登记卡.可繁) AS 可繁之Sum, Sum(奶牛登记卡.育成) AS 育成之Sum, Sum(奶牛登记卡.泌乳) AS 泌乳之Sum, Sum(奶牛登记卡.犊牛) AS 犊牛之Sum, Sum(奶牛登记卡.青贮窖) AS 青贮窖之Sum, Sum(奶牛登记卡.青贮量) AS 青贮量之Sum, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积之Sum, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量之Sum, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量之Sum
FROM 奶牛登记卡
GROUP BY "heji"
where (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"));作者: zhuyiwen 时间: 2002-4-13 23:48
SELECT 奶牛登记卡.所在乡镇, "合计" as 合计, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏, Sum(奶牛登记卡.可繁) AS 可繁, Sum(奶牛登记卡.育成) AS 育成, Sum(奶牛登记卡.泌乳) AS 泌乳之, Sum(奶牛登记卡.犊牛) AS 犊牛, Sum(奶牛登记卡.青贮窖) AS 青贮窖, Sum(奶牛登记卡.青贮量) AS 青贮量, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量
FROM 奶牛登记卡
GROUP BY 奶牛登记卡.所在乡镇
HAVING (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"));
UNION SELECT 所在乡镇, "" as 合计, 奶牛存栏, 可繁, 育成, 泌乳, 犊牛, 青贮量, 青贮窖, 牛舍面积, [2001年商品奶量], [2002年预计商品奶量]
FROM 奶牛登记卡
WHERE (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"))
ORDER BY 所在乡镇;