-
行列轉(zhuǎn)換case語句查看全部
-
2-5 select * from( select sum(kills) as "沙僧" from a join c on a.id=c.user_id and a.name="沙僧" )a cross join( select sum(kills) as "豬八戒" from a join c on a.id=c.user_id and a.name="豬八戒" )c cross join( select sum(kills) as "孫悟空" from a join c on a.id=c.user_id and a.name="孫悟空" )b; //其中括號后面的a b c 是給select語句結(jié)果表的命名查看全部
-
case語句 CASE WHEN 條件 THEN 要取的字段 END查看全部
-
查詢重復(fù)數(shù)據(jù),保留最大ID SELECT user_name,COUNT(*) FROM user1_test GROUP BY user_name HAVING COUNT(*)>1; 刪除重復(fù)數(shù)據(jù) DELETE a FROM user1_test a JOIN( SELECT user_name,COUNT(*),MAX(id) AS id FROM user1_test GROUP BY user_name HAVING COUNT(*)>1 )b ON a.user_name = b.user_name WHERE a.id < b.id查看全部
-
DECLARE v_cnt INT; DECLARE v_timestr INT; DECLARE rowcount BIGINT; SET v_timestr = DATE_FORMAT(NOW(),'%Y%m%d'); SELECT ROUND(RAND()*100,0)+1 INTO v_cnt; START TRANSACTION; UPDATE order_seq SET order_sn = order_sn + v_cnt WHERE timestr = v_timestr; IF ROW_COUNT() = 0 THEN INSERT INTO order_seq(timestr,order_sn) VALUES(v_timestr,v_cnt); END IF; SELECT CONCAT(v_timestr,LPAD(order_sn,7,0))AS order_sn FROM order_seq WHERE timestr = v_timestr; COMMIT;查看全部
-
刪除重復(fù)的數(shù)據(jù)!查看全部
-
刪除重復(fù)的數(shù)據(jù)!查看全部
-
使用序列化列轉(zhuǎn)行查看全部
-
行轉(zhuǎn)列查看全部
-
使用case 語句來實現(xiàn)行列轉(zhuǎn)換 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`;查看全部
-
g查看全部
-
行轉(zhuǎn)列技巧查看全部
-
行行列轉(zhuǎn)換demo查看全部
-
Bv查看全部
-
使用case 語句來實現(xiàn)行列轉(zhuǎn)換查看全部
舉報
0/150
提交
取消