摘要: 如何将两个表的字段并列起来?请看以下列子A表:col1123B表:col2ABC结果:col1col21A2B3C实现代码:select T1.col1,T2.col2 from (select col1,row_number() over(order by col1) as row_numfrom tb1)T1,(select col2,row_number() over(order by col2) as row_numfrom tb1)T2where T1.row_num = T2.row_num 阅读全文
posted @ 2013-03-11 11:01 海藻 阅读(1035) 评论(0) 推荐(0) 编辑