22,210
社区成员
发帖
与我相关
我的任务
分享
ID SetupID ML MH tc25 tc90
1 1 5.2 6.2 7.1 6.7
1 2 2.2 2.5 9.2 2.3
1 1 4.1 7.3 4.6 1.7
1 3 2.7 4.1 2.9 8.5
1 2 5.3 9.2 6.7 9.2
SELECT
CASE SETUPID WHEN '1' THEN [ML] ELSE 0 END AS lbml,
CASE SETUPID WHEN '1' THEN [MH] ELSE 0 END AS lbmh,
CASE SETUPID WHEN '1' THEN tc25 ELSE 0 END AS lbtc25,
CASE SETUPID WHEN '1' THEN tc90 ELSE 0 END AS lbtc90,
CASE SETUPID WHEN '1' THEN [ML] ELSE 0 END AS mnml,
CASE SETUPID WHEN '1' THEN [MH] ELSE 0 END AS mnmh,
CASE SETUPID WHEN '1' THEN [tc10] ELSE 0 END AS jstc10
FROM dbo.testdata
SELECT dbo.demo.SetipID AS SetipID,
--处理ML 这个是ID为1,2,3都显示,有点多余,不过帮你理解
CASE dbo.demo.SetipID
WHEN '1' THEN ML
WHEN '2' THEN ML
WHEN '3' THEN ML
END
AS lbml,
--MH只在ID1,2显示
CASE dbo.demo.SetipID
WHEN '1' THEN MH
WHEN '2' THEN MH
WHEN '3' THEN NULL
END
AS lbmh,
--tc25只在ID1显示
CASE dbo.demo.SetipID
WHEN '1' THEN tc25
WHEN '2' THEN NULL
WHEN '3' THEN NULL
END
AS lbtc25,
--tc90只在ID1显示
CASE dbo.demo.SetipID
WHEN '1' THEN tc90
WHEN '2' THEN NULL
WHEN '3' THEN NULL
END
AS lbtc90
FROM
dbo.demo