sql 面积求和笔记

本文记录了如何使用SQL查询来统计特定地区和年份的农作物种植总面积,详细探讨了涉及的数据表和关键查询技巧。
摘要由CSDN通过智能技术生成

根据数据表统计某地某年农作物种植面积

SELECT *from t_distribution ;
SELECT sum(area_num) as "2016总面积"  from t_distribution where ad_area_code LIKE '6103%' and current_year ='2016';
SELECT sum(area_num) as "2016小麦面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='0' and current_year ='2016';
SELECT sum(area_num) as "2016玉米面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='1' and current_year ='2016';
SELECT sum(area_num) as "2016其他面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='2' and current_year ='2016';

SELECT sum(area_num) as "2017总面积"  from t_distribution where ad_area_code LIKE '6103%' and current_year ='2017';
SELECT sum(area_num) as "2017小麦面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='0&#
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值