表A
============
A B
================
A1 10
A2 11
A3 14
A5 15
Select Decode(B,10,A1) As A1,
Decode(B,11,A1) As A1,
Decode(B,14,A1) As A3,
Decode(B,15,A1) As A5
From 表A
不知道能不能满足你的需要。
============
A B
================
A1 10
A2 11
A3 14
A5 15
Select Decode(B,10,A1) As A1,
Decode(B,11,A1) As A1,
Decode(B,14,A1) As A3,
Decode(B,15,A1) As A5
From 表A
不知道能不能满足你的需要。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货