举几个例子来说明ALL和ANY的用法
1. SELECT * FROM TABLEA WHERE FLD > ALL(SELECT FLD FROM TABLEA) 这相当于 SELECT * FROM TABLEA WHERE FLD > (SELECT MAX(FLD) FROM TABLEA)1. SELECT * FROM TABLEA WH
举几个例子来说明ALL和ANY的用法
1. SELECT * FROM TABLEA WHERE FLD > ALL(SELECT FLD FROM TABLEA) 这相当于 SELECT * FROM TABLEA WHERE FLD > (SELECT MAX(FLD) FROM TABLEA)1. SELECT * FROM TABLEA WH