-
列轉(zhuǎn)行2 select user_name,'arms' as equipment, arms from user1 a join user1_equipment b on a.id=user_id union all select user_name,'clothing' as equipment, clothing from user1 a join user1_equipment b on a.id=user_id; union all select user_name,'shoe' as equipment, shoe from user1 a join user1_equipment b on a.id=user_id;查看全部
-
列轉(zhuǎn)行 select user_name,replace(substring(substring_index(mobile,','a.id),char_length(substring_index(mobile,',',a.id-1))+1),',','') as mobile from tb_sequence as a cross join( select user_name,concat(mobile,',') as mobile,length(mobile)-length(replace(mobile,',',''))+1 as size from user1 as b) as b on a.id<=b.size查看全部
-
行列轉(zhuǎn)換 declare @sql nvarchar(1000) set @sql='select cl ' select @sql=@sql+',sum(case when ck='''+ck+''' then sl else 0 end) as '''+ck+'''' from table1 group by ck set @sql=@sql+' from table1, group by cl' execute sp_execute sql @sql查看全部
-
刪除字段中的重復(fù)數(shù)據(jù)查看全部
-
case實(shí)現(xiàn)行轉(zhuǎn)列。查看全部
-
處理重復(fù)數(shù)據(jù)查看全部
-
存儲(chǔ)過程查看全部
-
創(chuàng)建序列查看全部
-
列轉(zhuǎn)行的情景查看全部
-
先實(shí)現(xiàn)列轉(zhuǎn)行，用上節(jié)簡(jiǎn)單刪除，再轉(zhuǎn)回來查看全部
-
更復(fù)雜的情況查看全部
-
刪除重復(fù)數(shù)據(jù)查看全部
-
有很好的并發(fā)性查看全部
-
調(diào)用存儲(chǔ)過程來生成特殊的序列號(hào)查看全部
-
唯一序列號(hào)生成原則查看全部
舉報(bào)
0/150
提交
取消