select 村名,sum(case when 內容分類='家庭矛盾' then 1 end) 家庭矛盾, sum(case when 內容分類='自然災害、環境保護' then 1 end) 自然災害、環境保護, sum(case when 內容分類='經濟' then 1 end) 經濟, sum(case when 處理情況='已辦結' then 1 end) 已辦結，sum(case when 處理情況='正在辦結' then 1 end) 正在辦結,sum(case when 處理情況='未辦結' then 1 end) 未辦結 from table group by 村名
2. SQL 統計報表
-- create sample table
create table tab1 (id int, output_style char(1), amount int, output_date date);
insert into tab1 values(1,'D',1000,'2009-11-12');
insert into tab1 values(2,'C',1000,'2009-11-12');
insert into tab1 values(3,'G',1000,'2009-12-12');
insert into tab1 values(4,'Z',1000,'2010-01-01');
insert into tab1 values(5,'D',1300,'2009-11-12');
insert into tab1 values(6,'C',1400,'2009-11-12');
insert into tab1 values(7,'G',2000,'2009-12-12');
insert into tab1 values(8,'Z',1000,'2010-01-01');
-- query
select concat(year(output_date), month(output_date)) as yearmonth,
sum(case when output_style='C' then amount else 0 end) as C_Amount,
sum(case when output_style='G' then amount else 0 end) as G_Amount,
sum(case when output_style='Z' then amount else 0 end) as Z_Amount,
sum(case when output_style='D' then amount else 0 end) as D_Amount from tab1 group by output_date
3. 自定義報表能不能實現Sql的查詢統計功能
在系統中，增加一個報表管理模塊。
以配置的形式來進行，報表開發。
比如。grid++報表工具。
每一張報表，對應一個sql，這樣的話，就可以使用配置的方式。
---報表名字，報表ID，sql語句（或者是存儲過程），報表路徑--相信在展現報表的時候，一個公用的底層和公用的頁面。
就比如fusionchart，只是xml和flash不同而已。
完全可以配置到資料庫，用ID來區分不同的報表。
這樣寫你後期如果有這種業務需求的話，就可以很快的開發。
4. sqlserver 統計報表的 sql語句怎麼寫
--動態語句
declare@sqlvarchar(8000)
select@sql=isnull(@sql+'],[','')+NAMEfromT_CSDN_ONEgroupbyNAME
set@sql='['+@sql+']'
EXEC('select*from(select*fromT_CSDN_ONE)apivot(SUM(ISNULL(MONERY,0)forNAMEin('+@sql+'))b')
5. sql 月統計報表 按日顯示
select a.yd,cardmoney,c.fillmoney,d.fillmoney as fillmoney1,replacemoney,returnmoney,chargemoney from (
select '1' as yd union select '2' union select '3' union
select '5' union select '6' union select '7' union
select '8' union select '9' union select '10' union
select '11' union select '12') a
left join
(select month(addtime)as yd,sum(cardmoney)as cardmoney from Card where year(addtime) = '2009' group by month(addtime)) b
on a.yd=b.yd
left join
(select month(filldate)as yd,sum(fillmoney)as fillmoney from CardFillDate where year(filldate) = '2009' group by month(filldate)) c
on a.yd=c.yd
left join
(select month(filldate)as yd,sum(fillmoney)as fillmoney from CardFill where year(filldate) = '2009' group by month(filldate)) d
on a.yd=d.yd
left join
(select month(replacedate)as yd,sum(replacemoney)as replacemoney from CardReplace where year(replacedate) = '2009' group by month(replacedate)) e
on a.yd=e.yd
left join
(select month(recycledate)as yd,sum(returnmoney)as returnmoney from CardRecycle where year(recycledate) = '2009' group by month(recycledate)) f
on a.yd=f.yd
left join
(select month(outdate)as yd,sum(chargemoney)as chargemoney from Mainsavetable where year(outdate) = '2009' group by month(outdate)) g
on a.yd=g.yd order by cast(a.yd as int)
6. 這個銷售統計報表T-SQL怎麼寫
SELECTFirstName客戶,銷售總數量-ISNULL(退貨總數量,0)數量,售價總額-ISNULL(退貨售價總額,0)銷售總額,銷售成本總額-ISNULL(退貨成本總額,0)成本總額,
售價總額-退貨售價總額-(銷售成本總額-退貨成本總額)利潤總額
FROMCustomerKJOIN
(SELECTCustomerId,SUM(Quantity)銷售總數量,SUM(Quantity*Price)售價總額,SUM(CostPrice*Quantity)銷售成本總額
.SellFormId=M.SellFormId
WHEREChecked=1ANDDeleted=0ANDSellDateBETWEEN'20150101'AND'20150120'
GROUPBYCustomerId)XONK.CustomerID=X.CustomerID
LEFTJOIN
(SELECTCustomerId,SUM(Quantity)退貨總數量,SUM(Quantity*Price)退貨售價總額,SUM(CostPrice*Quantity)退貨成本總額
.SellReturnFormId=M.SellReturnFormId
WHEREChecked=1ANDSellReturnItemClass=0ANDReturnDateBETWEEN'20150101'AND'20150120'
GROUPBYCustomerId)TONK.CustomerID=T.CustomerID
7. 求助一個統計報表的SQL語句
SELECT SUM(入庫重量) AS 庫存, 貨物品種,貨物規格,貨主,入庫日期
FROM 表A
ORDER BY 貨物品種,貨物規格,貨主,入庫日期
你得詳細說一下你要的「入庫表重量之和」是多長時間之內的。上面我寫的是每天的入庫重量之和
8. SQL 數量 統計報表
改成這樣試試： SELECT dbo.HY_JBDA.姓名, dbo.HY_JBDA.年齡, dbo.HY_JBDA.戶籍, dbo.HY_JBDA.職業,
dbo.HY_JBDA.渠道名稱, dbo.HY_JBDA.居住區域 AS 居住地址,
dbo.HY_JBDA.客戶類別, dbo.HY_JBDA.會員卡類別 AS 客戶等級,
CASE dbo.HY_JBDA.會員卡類別
WHEN '普通卡' THEN 1
WHEN '成功卡' THEN 1
WHEN '卓越卡' THEN 1
WHEN '金卡' THEN 1
WHEN '鑽石卡' THEN 1
ELSE '0'
END AS 數量,
dbo.HY_JBDA.家庭結構, dbo.HY_JBDA.車型, dbo.HY_JBDA.會員卡類別
FROM dbo.HY_JBDA INNER JOIN
dbo.HY_DJQK ON dbo.HY_JBDA.會員編號 = dbo.HY_DJQK.會員編號
where dbo.HY_DJQK.登記日期 between '2007-01-01' and '2010-01-01'
9. SQL 報表統計 總計小計
select 月份,電費,管理費,雜費,餐費,其他,總計 from
(select cast((month(DATE)) as char(2)) as 月份一,cast((month(DATE))as char(2)) as 月份,
sum(case when OUTPUT_STYTLE='電費' then AMOUNT else 0 end) as 電費,
sum(case when OUTPUT_STYTLE='管理費' then AMOUNT else 0 end) as 管理費,
sum(case when OUTPUT_STYTLE='雜費' then AMOUNT else 0 end) as 雜費,
sum(case when OUTPUT_STYTLE='餐費' then AMOUNT else 0 end) as 餐費,
sum(case when OUTPUT_STYTLE='其他' then AMOUNT else 0 end) as 其他,
sum(case when ID>0 then AMOUNT else 0 end ) as 總計
from DB_DAILY_OUTPUT where(year(DATE)='"+year+"') group by (month(DATE))
union
select '13' as 月份一,'合計' as 月份,
sum(case when OUTPUT_STYTLE='電費' then AMOUNT else 0 end) as 電費,
sum(case when OUTPUT_STYTLE='管理費' then AMOUNT else 0 end) as 管理費,
sum(case when OUTPUT_STYTLE='雜費' then AMOUNT else 0 end) as 雜費,
sum(case when OUTPUT_STYTLE='餐費' then AMOUNT else 0 end) as 餐費,
sum(case when OUTPUT_STYTLE='其他' then AMOUNT else 0 end) as 其他,
sum(case when ID>0 then AMOUNT else 0 end ) as 總計
from DB_DAILY_OUTPUT where(year(DATE)='"+year+"') )a
order by 月份一