SQL查询以选择除最大值以外的所有内容

该

max

SELECt features.featureTitle AS title,    features.featureSummary AS body,     features.postedOn AS dummy,    DATE_FORMAT( features.postedOn,  '%M %d, %Y' ) AS posted,    NULL,    NULL,    staff.staffName,    features.featureID FROM     features     LEFT JOIN staff ON         features.staffID = staff.staffIDWHERe   features.postedOn != (select max(features.postedOn) from features)