ID_,NAME_,CODE_,GROUP_,VALUE_,ENCRYPT_,create_time_,DESCRIPTION_,UPDATE_TIME_,IS_DELE_,VERSION_ DELETE FROM uc_properties WHERE IS_DELE_=1 SELECT distinct GROUP_ FROM uc_properties WHERE IS_DELE_!=1 SELECT count(1) FROM uc_properties where CODE_=#{code} AND IS_DELE_!=1 and ID_ !=#{id} SELECT FROM uc_properties WHERE CODE_=#{code} AND IS_DELE_!=1