--没见别人这样用,但起码可以达到目的,不知道有没简单的方法,不想建表。 select @data_end_tag=max(tag) from ( select @end_tag_ctc1 as tag union select @end_tag_ctc2 as tag union select @end_tag_cnc1 as tag union select @end_tag_cnc2 as tag) t