Question

Oracle中如何将查询出来的数据当成一个新表用

Answer 1

可以用以下两种方式：

1、select xx from (select xx from tablename) ;

2、 WITH a AS (SELECT * FROM bd_member WHERE ROWNUM<10),
b AS (SELECT * FROM tp_trade_card)
select A.MEMBER_NAME,
B.CARD_NO
from A,
B
where A.BD_MEMBER_ID = B.BD_MEMBER_ID

Answer 2

select * from (select c1,c2,c3,c4 from table1 ) aa

Answer 3

查询出的结果就是一个表