select
a.workMon,
a.ColKey,
a.ColVal,
from
(select workMon,'UrlClp' as ColKey,UrlClp as ColVal,1 as ID from 表
union all
select workMon,'UrlHec' as ColKey,UrlHec as ColVal,2 as ID from 表
union all
select workMon,'UrlTtl' as ColKey,UrlTtl as ColVal,3 as ID from 表
union all
select workMon,'LarClp' as ColKey,LarClp as ColVal,4 as ID from 表
union all
select workMon,'LarHec' as ColKey,LarHec as ColVal,5 as ID from 表
union all
select workMon,'LarTtl' as ColKey,LarTtl as ColVal,6 as ID from 表) a
order by
a.workMon,a.ID
a.workMon,
a.ColKey,
a.ColVal,
from
(select workMon,'UrlClp' as ColKey,UrlClp as ColVal,1 as ID from 表
union all
select workMon,'UrlHec' as ColKey,UrlHec as ColVal,2 as ID from 表
union all
select workMon,'UrlTtl' as ColKey,UrlTtl as ColVal,3 as ID from 表
union all
select workMon,'LarClp' as ColKey,LarClp as ColVal,4 as ID from 表
union all
select workMon,'LarHec' as ColKey,LarHec as ColVal,5 as ID from 表
union all
select workMon,'LarTtl' as ColKey,LarTtl as ColVal,6 as ID from 表) a
order by
a.workMon,a.ID
解决方案 »
- 计算客户每种商品最后一次订货与第二次订货之间的间隔日期是多少?
- 两个表的关联查询问题,请高人指点!
- 好难写的sql啊,关于DISTINCT,大家来帮忙看下
- AD批量处理SQL出现的奇异问题,请解惑!
- 一个入门级的问题!~
- 有关存储过程,动态生成表,行列转换中含有特殊字符的问题,请大家帮忙!!!!!!!!!!!!!
- 求救!存储过程问题 在sql Server 中执行存储过程 正确,在PB中执行存储过程报错!
- sql语句真实功能强大,一直以为只有sql,今天才...寻求sql语句,多送
- spool on,spool temp.txt等是什么意思?
- 在 SQL Server 中使用命令出现错误
- 链接查询问题 高手指点下
- 在程序中如何中断一个查询或正在执行的存储过程
谢谢子陌~