表数据 拼接 去重,去空
select ROW_NUMBER() over() as RN,
tmp.* as SITE from
(
select B.A from
(
select distinct field1 A from table1
union
select distinct field2 A from table1
union
select distinct field3 A from table1
union
select distinct field4 A from table1
) B where B.A != ''
) tmp
over内可以加order by [字段] desc排序的语句