select decode(tts.is_lock,0,'false',1,decode(tts.execute_state,4,'false','true')) from twf_tech_schedule tts

sql判断语句

05-11 19:35