有时候在Oracle查询时需要建立临时表,可以简化查询,使读者更加清楚明白,在一个查询sql中,可以使用临时表。
用法:with tableName as(sql语句) select * from tableName...
例如:
- with a as --建立临时表
- (select sum(pt.c_all) sumall, q.c_createsupp
- from t_quotebill_part pt
- inner join t_quotebill q
- on pt.c_quotebill = q.c_id
- where q.c_enquirebill = 7741809513
- group by q.c_createsupp)
- select c_createsupp suppcode --使用临时表
- from a
- where a.sumall in (select min(sumall) from a)