-
刪除重復(fù)數(shù)據(jù)查看全部
-
刪除重復(fù)數(shù)據(jù)查看全部
-
處理重復(fù)數(shù)據(jù)查看全部
-
生成唯一序列號查看全部
-
生成唯一序列號查看全部
-
使用union行列轉(zhuǎn)換查看全部
-
行列轉(zhuǎn)換查看全部
-
case 語句實現(xiàn)行轉(zhuǎn) CASE WHEN 條件 THEN 要取的字段 END SELECT SUM(CASE WHEN u.`user_name` = '八戒' THEN k.`kills` END) AS '八戒', SUM(CASE WHEN u.`user_name` = '悟空' THEN k.`kills` END) AS '悟空' , SUM(CASE WHEN u.`user_name` = '沙僧' THEN k.`kills` END) AS '沙僧' FROM xyj_user_kills k JOIN xyj_user1 u ON k.`user_id` = u.`id`;查看全部
-
sql查看全部
-
union查看全部
-
case查看全部
-
行轉(zhuǎn)列技巧查看全部
-
老師講的真好 學(xué)習(xí)了查看全部
-
union all查看全部
-
select a.user_name,sum(kills) from user1 a join user_kills b on a.id = b.user_id group by a.user_name; select sum(case when user_name='孫悟空' then kills end) as '孫悟空', sum(case when user_name='豬八戒' then kills end) as '豬八戒'， sum(case when user_name='' then kills end) as '' from user1 a join user_kills b on a.id = b.user_id;查看全部
舉報
0/150
提交
取消