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 運(yùn)算符 (select 集合函數(shù)(column_name ) from table_name [where condition])

oracle嵌套查詢能套用聚合函數(shù)嗎？

可以、比如查詢成績(jī)最高的學(xué)生姓名

selct 姓名 from 學(xué)生表

where 學(xué)號(hào) in(select 學(xué)號(hào) from 選課表 where 成績(jī)=(select max(成績(jī)) from 選課表))