使用sql server 2008，两行应该在单行中 [英] Two rows should be in single Row using sql server 2008

问题描述

嗨朋友们，我在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





此处冒号仅用于识别。请任何帮助我...

解决方案

我会试着转动表格。这是一个获取最高数据的查询拉动吗？



这是一篇关于sql server table和pivoting / unpivoting的精彩文章。



http://blog.sqlauthority.com/2008/06/07 / sql-server-pivot-and-unpivot-table-examples / [ ^ ]

 选择 d.ID，d.Name，d.salary，da.Name，da.salary 
 来自数据 as  d 
  left   join 数据 as  da 
  on  d.ID = da.id 
  where  d.Name  in （'  RA m'，'  ravi'）
 和 da.Name = '  sdfsdf' 

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...

解决方案

I would try pivoting the table. Is this a query pull that is getting you that top data?

Heres a fellow with a great article on sql server tables and pivoting/unpivoting.

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

select  d.ID,d.Name,d.salary,da.Name,da.salary 
from Data as d
left join Data as da
on d.ID = da.id
where d.Name in ('ram','ravi')
and da.Name = 'sdfsdf'

这篇关于使用sql server 2008，两行应该在单行中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！