谁说不可以。
15:00:54 SQL> select (select max(col1) from tb where col2 between 'a' and 'e') from tb;(SELECTMAX
----------
d
d
d你如果返回过个值的话就有问题了
15:00:54 SQL> select (select max(col1) from tb where col2 between 'a' and 'e') from tb;(SELECTMAX
----------
d
d
d你如果返回过个值的话就有问题了
select * from table1 where temperature between 20 and (select max(temperature) from table2);
select * from student_1 where sage between 10 and (select max(sage) from student_2);
17:14:28 SQL> select 1 from dual where 'c' between 'a' and (select max(col1) from tb); 1
----------
1已用时间: 00: 00: 00.16
17:19:03 SQL>