-- 列转行(UNPIVOT)
select row_number () OVER ( ORDER BY a) rows_no,a,列4 from 表1 unpivot (列4 for a in (列1, 列2, 列3)) as a