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