SQL 語句

[yifan1008]

有表 TT 查詢結果 如下
字段 T1 T2 T3
6223 1699 1537

想求得語句的查詢結果是
字段 項目 類別
T1 6223
T2 1699
T3 1537

[pt1314917]

select 项目='T1',类别=T1 from 表名
union all
select 项目='T2',类别=T3 from 表名
union all
select 项目='T3',类别=T3 from 表名

[-狙击手-]

select 'T1' as 項目,T1 as 類別 from tt  union all
select 'T2' as 項目,T2 as 類別 from tt  union all
select 'T3' as 項目,T3 as 類別 from tt 

[Limpire]

select 项目='T1', 類別=T1 from TT
union all
select 项目='T2', 類別=T2 from TT
union all
select 项目='T3', 類別=T3 from TT

[lff642]

select 项目='T1',类别=T1 from 表名
union all
select 项目='T2',类别=T3 from 表名
union all
select 项目='T3',类别=T3 from 表名

[arrow_gx]

行转列的问题

create   table   t   
  (col1   int,col2   int,col3   int)   
    
  insert   t   
  select   1,2,3   union   all   
  select   4,5,6   
    
  declare   @sql   varchar(8000),   
                  @sql1   varchar(8000),   
                  @sql2   varchar(8000),   
                  @sql3   varchar(8000)   
    
  select   @sql='',@sql1='select   ''a''   ',@sql2='select   ''b''',@sql3='select   ''c'''   
    
  select   @sql1=@sql1+','+cast(col1   as   varchar),   
                @sql2=@sql2+','+cast(col2   as   varchar),   
                @sql3=@sql3+','+cast(col3   as   varchar)   
  from   t   
    
  select   @sql='create   table   #(col1   varchar(20),col2   int,col3   int)   insert   #   
                          '+@sql1+'   union   all   
                          '+@sql2+'   union   all   
                          '+@sql3+'   
                          select   *   from   #   
                          drop   table   #'   
    
  exec(@sql)   
  drop   table   t   
    
  col1                                   col2                 col3                   
  --------------------   -----------   -----------     
  a                                         1                       4   
  b                                         2                       5   
  c                                         3                       6   

[zhou968]

select 项目='T1',类别=T1 from 表名
union all
select 项目='T2',类别=T3 from 表名
union all
select 项目='T3',类别=T3 from 表名