|
單數(shù)差:sum(ORDERNUM(2,0)-ORDERNUM(1,0),0); 特大買(mǎi)單:sum(ORDERNUM(1,3),0); 特大賣(mài)單:sum(ORDERNUM(2,3),0); 大買(mǎi)單:sum(ORDERNUM(1,2),0); 大賣(mài)單:sum(ORDERNUM(2,2),0); 中買(mǎi)單:sum(ORDERNUM(1,1),0); 中賣(mài)單:sum(ORDERNUM(2,1),0); 筆數(shù)差:sum(TRANSACTNUM(1,0)-TRANSACTNUM(2,0),0); 特大買(mǎi):sum(TRANSACTNUM(1,3),0); 特大賣(mài):sum(TRANSACTNUM(2,3),0); 大買(mǎi):sum(TRANSACTNUM(1,2),0); 大賣(mài):sum(TRANSACTNUM(2,2),0); 中買(mǎi):sum(TRANSACTNUM(1,1),0); 中賣(mài):sum(TRANSACTNUM(2,1),0); |
|
|
