第一条:
SELECT CODE,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2',1,0) ) IN20,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2',0,1) ) IN40,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y20',1,0)) DM20,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y40',1,0)) DM40
FROM CTDLEM
WHERE
(INDATE>:E_TIME AND INDATE<:MY_NOW ) AND
(OPERATIONCODE='RE' OR OPERATIONCODE='RF' OR OPERATIONCODE='IE' OR OPERATIONCODE='IF')
GROUP BY CODE第二条:
SELECT CODE,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2','20',1,0)) OUT20,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2','20',0,1)) OUT40,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y20',1,0)) DM20,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y40',1,0)) DM40
FROM CTDLEM
WHERE
(OUTDATE>:E_TIME AND OUTDATE<:MY_NOW ) AND
(OPERATIONCODE='DE' OR OPERATIONCODE='DF' OR OPERATIONCODE='EE' OR OPERATIONCODE='EF')
GROUP BY CODE如下图:code in20 in40 dm20 dm40 out20 out40 dm20 dm40
-----------------------------------------------
A 1 1 0 0 2 2 0 0
B 0 0 1 0 0 0 1 0
C 2 0 0 1 1 0 0 1
D 2 2 1 1 0 0 1 1
SELECT CODE,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2',1,0) ) IN20,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2',0,1) ) IN40,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y20',1,0)) DM20,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y40',1,0)) DM40
FROM CTDLEM
WHERE
(INDATE>:E_TIME AND INDATE<:MY_NOW ) AND
(OPERATIONCODE='RE' OR OPERATIONCODE='RF' OR OPERATIONCODE='IE' OR OPERATIONCODE='IF')
GROUP BY CODE第二条:
SELECT CODE,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2','20',1,0)) OUT20,
SUM(DECODE(SUBSTR(SIZETYPE,1,1),'2','20',0,1)) OUT40,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y20',1,0)) DM20,
SUM(DECODE(IN_DAMAGE||DECODE(SUBSTR(SIZETYPE,1,1),'2','20','40'),'Y40',1,0)) DM40
FROM CTDLEM
WHERE
(OUTDATE>:E_TIME AND OUTDATE<:MY_NOW ) AND
(OPERATIONCODE='DE' OR OPERATIONCODE='DF' OR OPERATIONCODE='EE' OR OPERATIONCODE='EF')
GROUP BY CODE如下图:code in20 in40 dm20 dm40 out20 out40 dm20 dm40
-----------------------------------------------
A 1 1 0 0 2 2 0 0
B 0 0 1 0 0 0 1 0
C 2 0 0 1 1 0 0 1
D 2 2 1 1 0 0 1 1
解决方案 »
- vista下操作注册表
- 关于Mediaplayer的问题---------今天结贴
- dbf数据导入到sql server 2000
- fyje(云中仙) 请进:昨天开贴散分,你是一楼,这里给你补60分
- 这个程序怎么做?运行出问题!请教高手!
- 如何重画ListView的某列(SubItem)?
- Borland Delphi 7 Studio Enterprise序列号,急着要。高分
- 各位有没有数据库连接的程序段(COM的),我要求可以打开连接,并且可以滚动取出数据,谢谢
- 在delphi里如何解决bit移位的问题
- 棘手,如何在一个程序中创建两个顶层窗口?
- 关于Pos机打印出乱码的问题
- 请问如何更改delphi运行得到的exe文件的图标?
Select * from (A union B) order by....
from (第一条) a left join (第二条) b on a.code=b.code