--根據emp,dept表求工資次高的雇員信息(考慮并列情況)
select?*?from?emp?where?sal?>=?all(select?sal?from?emp?where?sal?！=?'5000')
and?sal<(select?sal?from?emp?where?sal?>=?all(select?sal?from?emp));
下面的Oracle語句為什么要加上and后面的語句才可以？不加的話，前面的子查詢里已經去掉了5000
java2016817
2016-09-09 00:25:44