如何将一个表中的两列组合成sql server中的一列 [英] how to combine two columns in one table into one column in sql server

问题描述

我想在我的表格中选择一些数据。这是我在表格中的列

seq int，

值小数，

更改小数值，



seq值更改值

1 20 0.00

2 30 0.00

3 40 0.00

4 50 0.00

5 60 62.00





我想在流动表中选择更改值列！= 0.00和值列。



seq ALLValue

1 20

2 30

3 40

4 50

5 62（删除60并添加更改值列62 / seq数字不能重复）



如何解决这个问题任何人都可以帮助我？

解决方案

< blockquote> http://stackoverflow.com/questions/16062825/combine-two-columns-in-one-column [< a href =http://stackoverflow.com/questions/16062825/combine-two-columns-in-one-columntarget =_ blanktitle =New Window> ^ ]

http：// stackoverflow.com/questions/1398333/sql-server-combining-two-columns-as-one-column-if-a-conditions-happens [ ^ ]

 选择 
 Seq 
 
， CASE  
  WHEN  [更改值] =  0  那么 [Val ue] 
  ELSE  [更改价值] 
  END   AS  [所有值] 
 
  FROM  dbo.YourTable 

I want to select a some data in my table.this is my column in table
seq int,
Value decimal,
Change value decimal,

seq Value Change value
1 20 0.00
2 30 0.00
3 40 0.00
4 50 0.00
5 60 62.00


I want to select Change value column != 0.00 and value column in like flowing table.

seq ALLValue
1 20
2 30
3 40
4 50
5 62 (remove 60 and add change value column 62/seq number can't be duplicate)

How to solve this problem Any one can help me??

解决方案

http://stackoverflow.com/questions/16062825/combine-two-columns-in-one-column[^]
http://stackoverflow.com/questions/1398333/sql-server-combining-two-columns-as-one-column-if-a-conditions-happens[^]

select 
       Seq

      , CASE
          WHEN [Change Value] = 0 THEN [Value]
          ELSE [Change Value]
       END AS [ALL Value]

FROM dbo.YourTable

这篇关于如何将一个表中的两列组合成sql server中的一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！