作者imio24 (imio)
看板Database
标题[SQL ]Oracle Query的问题
时间Sun Mar 18 00:15:19 2012
Query 1:
select ord_dept_no,sum(decode(ord_emp_no||dev_emp_no,'115107', quantity)) quantity_1,
sum(decode(ord_emp_no||dev_emp_no,'115102', quantity)) quantity_2
from tableA
group by ord_dept_no
Query 2:
select ord_dept_no, sum(decode(p.category_cd, '???', o.quantity)) a,
sum(decode(p.category_cd, '?????', o.quantity)) b
from rders o, tableB p
where o.prod_id = p.prod_id
group by ord_dept_no
Query 3:
select/*+rule*/ ord_dept_no, sum(decode(p.category_cd, '???', o.quantity)) a,
sum(decode(p.category_cd, '?????', o.quantity)) b,
sum(decode(ord_emp_no||dev_emp_no,'115107', quantity)) quantity_1,
sum(decode(ord_emp_no||dev_emp_no,'115102', quantity)) quantity_2
from tableA o, tableB p
where o.prod_id = p.prod_id(+)
group by ord_dept_no
请问query 1 and query 2 的结果会和query 3一样吗...我要如何写可以把query 1 and query 2 写在一起..谢谢..
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 67.80.69.62
1F：→ jimbosanho:你是不是漏打了 rders这个table？ 03/25 07:20