17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT '1050', BIS_PART, BIS_STORE, BIS_BIN, SUM(BIS_QTY), '全盘'
FROM
(SELECT * FROM
(SELECT STO_PART, STO_STORE
FROM REPAIR_STOCK
WHERE STO_QTY <> 0
AND STO_STORE = '2'
ORDER BY DBMS_RANDOM.RANDOM)
WHERE ROWNUM < 5) PAR,
REPAIR_BINSTOCK
WHERE STO_STORE = BIS_STORE
AND STO_PART = BIS_PART
AND BIS_QTY <> 0
GROUP BY BIS_PART, BIS_STORE, BIS_BIN
为子查询起一个别名
select * from
(
select sysdate form dual
) par
--子查询结果集的别名。。和下面的TT意思一样。。
SQL> SELECT *
2 FROM (SELECT 'CSDN-ORACLE' MYSTR FROM DUAL)TT;
MYSTR
-----------
CSDN-ORACLE
[Quote=引用楼主 commemoration 的帖子:]