qq_25691983的博客

select match_uni_key,count(*) as count from t_match_msg_res_cache group by match_uni_key having count>1;

SELECT match_uni_key,origin_type,MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘1X2’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘1X2_half_origin_disc’,MAX(CAS...

SELECT CONCAT(’,"’,uni_key, ‘"’),uni_key FROM A WHERE NOT EXISTS (SELECT match_uni_key from B WHERE B.match_uni_key = A.uni_key) AND A.read_state IN(‘9’, ‘10’)A表中的uni_key字段和B表中match_uni_key字段关联SQL查询...