--根據(jù)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語(yǔ)句為什么要加上and后面的語(yǔ)句才可以？不加的話，前面的子查詢(xún)里已經(jīng)去掉了5000
java2016817
2016-09-09 00:25:44