Question

oracle 从一列中每次提取一个数值查询

oracle 从一列中每次提取一个数值查询 如：某列有a,b,c,d,e,f行，如何实现从这列中先提取a进行查询，在提取b进行查询？

Answer 1

with A as
(select * from 表 where =a),
B as
(select * from A),
C as
(select * from B),
select * from c

Answer 2

select * from test where a = b;

追问

不是，我是想将a提出来后作为另一个查询的条件，然后再将b提出来，再作为查询条件循环

追答

select a from test where (select b from test where (select c from test));
这样？》？》