oracle select嵌套select Oracle嵌套查询的格式谢谢？
Oracle嵌套查询的格式谢谢？Select select_list from table_name where column_name in(select column_name from tabl
Oracle嵌套查询的格式谢谢？
Select select_list from table_name where column_name in(select column_name from table_name where condition)Select select_list from table_name where column_name 运算符 (select 集合函数(column_name ) from table_name [where condition])
oracle嵌套查询能套用聚合函数吗？
可以、比如查询成绩最高的学生姓名
selct 姓名 from 学生表
where 学号 in(select 学号 from 选课表 where 成绩=(select max(成绩) from 选课表))