zhuyiwen近來(lái)

tianshi

SELECT 奶牛登記卡.所在鄉(xiāng)鎮(zhèn), 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年預(yù)計(jì)商品奶量]) AS 2002年預(yù)計(jì)商品奶量之Sum
FROM 奶牛登記卡
GROUP BY 奶牛登記卡.所在鄉(xiāng)鎮(zhèn)
HAVING (((奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="二道灣鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="友誼鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富裕鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="龍安橋鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="繁榮鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="紹文鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="忠厚鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="塔哈鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富路鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富海鎮(zhèn)"));

這是個(gè)按地址所建立的查詢，要查詢出10各不同地點(diǎn)的合計(jì)數(shù)，我的問(wèn)題是在這個(gè)查詢中，求出10各地點(diǎn)的總合。包括里面的每一個(gè)項(xiàng)目。

access91

SELECT 奶牛登記卡.所在鄉(xiāng)鎮(zhèn), 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年預(yù)計(jì)商品奶量]) AS 2002年預(yù)計(jì)商品奶量之Sum
FROM 奶牛登記卡
GROUP BY 奶牛登記卡.所在鄉(xiāng)鎮(zhèn)
HAVING (((奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="二道灣鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="友誼鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富裕鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="龍安橋鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="繁榮鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="紹文鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="忠厚鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="塔哈鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富路鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富海鎮(zhèn)")) 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年預(yù)計(jì)商品奶量]) AS 2002年預(yù)計(jì)商品奶量之Sum
FROM 奶牛登記卡
GROUP BY "heji"
where (((奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="二道灣鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="友誼鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富裕鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="龍安橋鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="繁榮鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="紹文鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="忠厚鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="塔哈鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富路鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富海鎮(zhèn)"));

zhuyiwen

SELECT 奶牛登記卡.所在鄉(xiāng)鎮(zhèn), "合計(jì)" as 合計(jì), Sum(奶牛登記卡.奶牛存欄) AS 奶牛存欄, Sum(奶牛登記卡.可繁) AS 可繁, Sum(奶牛登記卡.育成) AS 育成, Sum(奶牛登記卡.泌乳) AS 泌乳之, Sum(奶牛登記卡.犢牛) AS 犢牛, Sum(奶牛登記卡.青貯窖) AS 青貯窖, Sum(奶牛登記卡.青貯量) AS 青貯量, Sum(奶牛登記卡.牛舍面積) AS 牛舍面積, Sum(奶牛登記卡.[2001年商品奶量]) AS 2001年商品奶量, Sum(奶牛登記卡.[2002年預(yù)計(jì)商品奶量]) AS 2002年預(yù)計(jì)商品奶量
FROM 奶牛登記卡
GROUP BY 奶牛登記卡.所在鄉(xiāng)鎮(zhèn)
HAVING (((奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="二道灣鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="友誼鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富裕鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="龍安橋鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="繁榮鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="紹文鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="忠厚鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="塔哈鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富路鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富海鎮(zhèn)"));

UNION SELECT 所在鄉(xiāng)鎮(zhèn), "" as 合計(jì), 奶牛存欄, 可繁, 育成, 泌乳, 犢牛, 青貯量, 青貯窖, 牛舍面積, [2001年商品奶量], [2002年預(yù)計(jì)商品奶量]
FROM 奶牛登記卡
WHERE (((奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="二道灣鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="友誼鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富裕鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="龍安橋鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="繁榮鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="紹文鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="忠厚鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="塔哈鄉(xiāng)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富路鎮(zhèn)" Or (奶牛登記卡.所在鄉(xiāng)鎮(zhèn))="富海鎮(zhèn)"))
ORDER BY 所在鄉(xiāng)鎮(zhèn);

哈哈，與樓上老兄同出一轍！

[此貼子已經(jīng)被zhuyiwen于2002-4-13 15:47:46編輯過(guò)]

tmtony

我看著眼有點(diǎn)暈
好象到處都是奶牛呢 ：）

大熊

富裕鎮(zhèn),繁榮鄉(xiāng)，真是這名字嗎？太好笑了！

zhuyiwen

哈哈~~~~