作者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