SQL横着显示结果

来源：百度知道 编辑：UC知道 时间：2024/06/06 13:27:40
SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%'FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '301%'
SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%'FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '302%'
SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%'FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '303%'
SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%'FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '304%'
我想这4个结果能横着显示应该怎么写啊？？？
2楼的说用case，怎么用啊？
写出来啊~！！谢谢了
随便哪个都有这个问题~！！！
服务器: 消息 156，级别 15，状态 1，行 9
在关键字 'SELECT' 附近有语法错误。
服务器: 消息 170，级别 15，状态 1，行 18
第 18 行: ')' 附近有语法错误。
(SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%' as a FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '301%'
SELECT CA

select
max(case when rownum=1 then a else null end)
, max(case when rownum=2 then a else null end)
, max(case when rownum=3 then a else null end)
......
from
(SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%' as a FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '301%'
SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%' as a FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '302%'
SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%' as a FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '303%'
SELECT CAST((SUM(TH007-TH015)/SUM(TH007))*100 AS VARCHAR(100)) +'%' as a FROM PURTH WHERE TH015<>TH007
AND TH004 LIKE '304%') a

这个方法，要知道检索出有多少 行，才行，

试试下面的：增加一列，rn,
select max(case when rn =1 then a else null end )
,max(case when rn =2 then a else null end)
,m