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块钱真便宜
相关阅读
HELP! need info on QBE(Query By Example)斑竹们呢?[转载] Oracle Database Administrator (DBA) and Developer急! 急!向sybase表中插入数据不好用?HOW TO JUDGE THE FRAGMENT OF SQLSERVER DBIBM Overtakes Oracle In Database RaceSQL Server的DTS?[转载] 请辞database版版主[转载] How to remote access the Access Database file besides through System DSN?how to get primary key through JDBC?primary key?哭诉!How about JDBC for mysql?who has heard of redbrick怎样从WEB上执行调用DTS TASK?what is PL/SQL ?hehe, a trivial yet annoying question请问什么地方有关系代数之类的数据库基础理论知识啊?Just哪里有DOWNLOAD中文数据库入门的书呢?