问题描述
嗨朋友们,我在sqlserver中有要求,这里的问题是
ID ------- ----姓名-------------薪水(仅限于此)
1 ----------- ram ------------ 20000
1 ------ ----- sdfsdf ------------ 2000000
2 ----------- ravi-- ---------- 220000
2 ----------- sdfsdf ---------- - 555500
我想在下面这样:
ID ----------- Name1 ------------- salary1 ------- Name2 ------------薪水2
1 ------------ ram --------------- - 20000 --------- sdfsdf ------------ 2000000
2 ------------- ravi-- --------------- 220000 ------- sdfsdf ------------- 555500
此处冒号仅用于识别。请任何帮助我...
Hi friends, i have requirement in sqlserver, Here problem is
ID -----------Name -------------salary (like that only)
1 ----------- ram ------------ 20000
1 ----------- sdfsdf------------ 2000000
2 ----------- ravi------------ 220000
2 ----------- sdfsdf------------ 555500
I want to below like that:
ID-----------Name1 -------------salary1-------Name2------------salary2
1------------ ram---------------- 20000--------- sdfsdf------------2000000
2------------- ravi----------------- 220000------- sdfsdf-------------555500
Here colon is only for identification. please any help me...
这篇关于使用sql server 2008,两行应该在单行中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!