SQL

联合

Union和Union All

SELECT app_id,develop_company_id,rank,active_nums,active_nums_ratio FROM game_top_rank 
WHERE arith_id = 3 AND STATUS = 1 AND stat_date = '2017-08-01'
UNION ALL
SELECT app_id,develop_company_id,rank,active_nums,active_nums_ratio FROM top_rank WHERE arith_id = 3 AND STATUS = 1 AND stat_date = '2017-08-01'

COALESCE （）

COALESCE是一个函数， (expression_1, expression_2, ...,expression_n)依次参考各参数表达式，遇到非null值即停止并返回该值。如果所有的表达式都是空值，最终将返回一个空值 COALESCE(ui.telephone,ui.email,ui.username) cas_name2,

转载于:https://my.oschina.net/jiangbang/blog/3078213