s*d
2 楼
谢谢了。
select available.company_id, available.currency, available.sum, pending_paid
.sum
from (
(select company_id, currency, sum(value) as sum from
member_transactions where status ='A'
group by currency, company_id) as available
inner join
(select company_id, currency, sum(value) as sum from
member_transactions where status ='P'
group by currency, company_id) as pending_paid
on available.company_id=pending_paid.company_id
and available
select available.company_id, available.currency, available.sum, pending_paid
.sum
from (
(select company_id, currency, sum(value) as sum from
member_transactions where status ='A'
group by currency, company_id) as available
inner join
(select company_id, currency, sum(value) as sum from
member_transactions where status ='P'
group by currency, company_id) as pending_paid
on available.company_id=pending_paid.company_id
and available
s*d
4 楼
解决了,去掉“as"就好了
B*g
6 楼
select company_id, currency, sum(DECODE(status, 'A', value, 0)) as A_sum , s
um(DECODE(status, 'P', value, 0)) as p_sum
from member_transactions
where status ='A' OR status ='P'
group by currency, company_id
paid
【在 s******d 的大作中提到】
: 谢谢了。
: select available.company_id, available.currency, available.sum, pending_paid
: .sum
: from (
: (select company_id, currency, sum(value) as sum from
: member_transactions where status ='A'
: group by currency, company_id) as available
: inner join
: (select company_id, currency, sum(value) as sum from
: member_transactions where status ='P'
um(DECODE(status, 'P', value, 0)) as p_sum
from member_transactions
where status ='A' OR status ='P'
group by currency, company_id
paid
【在 s******d 的大作中提到】
: 谢谢了。
: select available.company_id, available.currency, available.sum, pending_paid
: .sum
: from (
: (select company_id, currency, sum(value) as sum from
: member_transactions where status ='A'
: group by currency, company_id) as available
: inner join
: (select company_id, currency, sum(value) as sum from
: member_transactions where status ='P'
l*e
7 楼
不懂,看着挺亮堂的。
d*r
10 楼
民国仿的。小拍可能还能卖点钱。傻人太多,就只会认款。
d*r
14 楼
看看最近卖的贵的一次。大傻骗了一傻波伊。
http://www.bonhams.com/cgi-bin/public.sh/pubweb/publicSite.r?sContinent=USA&screen=lotdetailsNoFlash&iSaleItemNo=4298749&iSaleNo=17321&iSaleSectionNo=1
【在 T*****n 的大作中提到】
: 俺个人看法,觉得民国都到不了
http://www.bonhams.com/cgi-bin/public.sh/pubweb/publicSite.r?sContinent=USA&screen=lotdetailsNoFlash&iSaleItemNo=4298749&iSaleNo=17321&iSaleSectionNo=1
【在 T*****n 的大作中提到】
: 俺个人看法,觉得民国都到不了
f*0
15 楼
xixi..竟然拍了$5185。。。。
这个是我在家旁边一个estate sale 上10刀买的,可惜那天去晚了好多东西都被提前排
队等着的人买走了。
【在 d*******r 的大作中提到】
: 看看最近卖的贵的一次。大傻骗了一傻波伊。
: http://www.bonhams.com/cgi-bin/public.sh/pubweb/publicSite.r?sContinent=USA&screen=lotdetailsNoFlash&iSaleItemNo=4298749&iSaleNo=17321&iSaleSectionNo=1
这个是我在家旁边一个estate sale 上10刀买的,可惜那天去晚了好多东西都被提前排
队等着的人买走了。
【在 d*******r 的大作中提到】
: 看看最近卖的贵的一次。大傻骗了一傻波伊。
: http://www.bonhams.com/cgi-bin/public.sh/pubweb/publicSite.r?sContinent=USA&screen=lotdetailsNoFlash&iSaleItemNo=4298749&iSaleNo=17321&iSaleSectionNo=1
l*e
16 楼
赶快列到ebay商去钓鱼。。
H*s
18 楼
也就几十年的东西。不过10块钱真便宜
相关阅读
ole db driver for DB2 needed请问:如何在Oracle8开始?Re: Oracle DBA 考试资料?Got demo testDatabase Professional Design SoftwareOracle DBA 考试资料?oracle里有些怪怪的表,不只是哪里来的?Where can I download Cold Fusion?遇到sql 的日期型字段不会使用SQL2000XML question菜鸟问题: 请问现在的数据库的远程管理能做到那些?是否可以完全取代本地机器的管理?求助:SQL Fulltext search不干活了。请教: 如何用Perl连接Oracle数据库?What API(for the C language) can i call to get the error message for an SQLCODE?高手指点:如何让Windows NT上的Mircosoft Access与MVS mainframe上的COBOL/DB2一起工作?help! oracle8i client installation on Windows2000/NT4Foolish question #1:请问mysql是否存在内存泄漏的问题?Oracle SQL code question???????????????SQL Server multiprotocolRe: [转载] Oracle将发布最新数据库产品Oracle9i!follow-up