在db2中有个字段是date类型,如何取最小值?有null值的话怎么让它不显示null值,只显示最小值
tryselect dateFiled from t where not(dateFiled is NULL) order by dateFiled asc limit 1;orselect min(dateFiled) from t where not(dateFiled is NULL) ;