--
没见别人这样用,但起码可以达到目的,不知道有没简单的方法,不想建表。
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
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