这个语句怎么写？？？？？？？？？？急求！！！！！！！！！！！

zhangwlkw 2012-09-20 10:42:46

SELECT OFU.A,OFU.NUM1,OS.NUM2, CONVERT((DECIMAL(10,2), CONVERT((DECIMAL(10,2),OS.NUM2)/OFU.NUM1)
FROM (SELECT F_A,COUNT(*) NUM1
FROM CR
WHERE F_ITime>= to_date('2008-12-27','yyyy-mm-dd')
AND ITime < to_date('2008-12-27','yyyy-mm-dd')
AND S IN (0,1,2)
AND SType IN (10,17)
HAVING COUNT(*)>0)OFU
INNER JOIN (SELECT A,COUNT(*) NUM2
FROM CR
WHERE ITime>= to_date('2008-12-27','yyyy-mm-dd')
AND ITime < to_date('2008-12-27','yyyy-mm-dd')
AND F_SResult = '110' AND F_ServiceMode IN (0,1,2)
AND F_SType IN (10,17)
GROUP BY A
HAVING COUNT(*)>0)OS ON OS.A = OFU.A

ORACLE怎么写啊？？？？？？？？？？？？

...全文

46 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

fw0124 2012-09-20

打赏
举报

SELECT OFU.A,OFU.NUM1,OS.NUM2, to_char(to_number(OS.NUM2)/OFU.NUM1, '99999999.99'),

  FROM (SELECT F_A,COUNT(*) NUM1

  FROM CR

  WHERE F_ITime>= to_date('2008-12-27','yyyy-mm-dd')

  AND ITime < to_date('2008-12-27','yyyy-mm-dd')

  AND S IN (0,1,2)

  AND SType IN (10,17)

  HAVING COUNT(*)>0)OFU  

  INNER JOIN (SELECT A,COUNT(*) NUM2

  FROM CR

  WHERE ITime>= to_date('2008-12-27','yyyy-mm-dd')

  AND ITime < to_date('2008-12-27','yyyy-mm-dd')

  AND F_SResult = '110' AND F_ServiceMode IN (0,1,2)

  AND F_SType IN (10,17)

  GROUP BY A

  HAVING COUNT(*)>0)OS ON OS.A = OFU.A