[SQL ]Oracle Query的問題
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
→
03/25 07:20, , 1F
03/25 07:20, 1F