简单的UATATE一个表A,有字段LEG和IS_MAX,当LEG取最大时的那条数据的IS_MAX字段设成“Y”怎么写?[解决办法]Update A Set IS_MAX = 'Y ' Where LEG = (Select MAX(LEG) From A)[解决办法]Update A Set IS_MAX = 'Y ' Where LEG = (Select max(b.LEG) From A b)