小白新手一位。
如何把第一行豎排在一個叫name的欄位下？然后數字豎排在叫total的欄位下？
uj5u.com熱心網友回復：
就這幾個欄位，老老實實寫一下就好了
select 'a' as name, a as total from sometable union all
select 'a(1)' as name, a(1) as total from sometable union all
select 'a(2)' as name, a(2) as total from sometable union all
select 'a(3)' as name, a(3) as total from sometable union all
select 'a(4)' as name, a(4) as total from sometable
uj5u.com熱心網友回復：
select 'a' as name, a as total from sometable union all
select 'a(1)' as name, [a(1)] as total from sometable union all
select 'a(2)' as name, [a(2)] as total from sometable union all
select 'a(3)' as name, [a(3)] as total from sometable union all
select 'a(4)' as name, [a(4)] as total from sometable
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/225738.html
標籤：基礎類
上一篇：無人機后期處理Pix4D遇到這種情況怎么辦 求大神指點
下一篇：SQL查詢只更新過的記錄