当我在MS Sql中使用Condition时如何拆分列. [英] How to split Column when i using Condition in MS Sql.

问题描述

尊敬的先生，

现在我使用sql server2005.

使用条件时如何将列拆分为2个单独的列.


例如:

列名称:性别好的
列有，

女
男性

现在我要

母柱和公柱

While Condition Check ...(如果有情况，则任何人都可以)


BY mohan

dear sir,

Now i using sql server 2005.

how to split column into 2 seperate column when i using condition.


example:

Column name : Gender ok
Column have,

Female
Male

Now i want

Female Column and Male Column

While Condition Check...(if,case,while anyone ok)


BY mohan

推荐答案

使用以下查询:

Use the following query:

select column1, '' as Female, Gender as Male from tablename where gender = 'Male'
union
select column1, Gender as Female, '' as Male from tablename where gender = 'Female'

这篇关于当我在MS Sql中使用Condition时如何拆分列.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！