这是我的表格显示，我希望在特定日期的州数量 [英] this is my table show bellow,,i want amount of states,on particular date

问题描述

州pay_branch receive_date payment_amount收据

AND SBI 13/11/2013 20000 0

ANP sbi 13/11/2013 50000 0

GUJ PNB 13/11/2013 0

state paying_branch receive_date payment_amount receipts
AND SBI 13/11/2013 20000 0
ANP sbi 13/11/2013 50000 0
GUJ PNB 13/11/2013 0

i want out put like this formate only

receive_date AND ANP GUJ

13/11 / 2013 20000 50000 0

receive_date AND ANP GUJ
13/11/2013 20000 50000 0

推荐答案

如果您使用SQL Server作为后端数据源，那么最简单的方法是 PIVOT [ ^ ]实际检索时的数据。

If you are using SQL Server as your backend data source, then the easiest way is to PIVOT[^] the data while you are actually retrieving it.

< a href =http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/ >清楚明了

这篇关于这是我的表格显示，我希望在特定日期的州数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！