摘要:
如何将两个表的字段并列起来?请看以下列子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
海藻
阅读(1050)
评论(0)
推荐(0)
浙公网安备 33010602011771号