注意2点:
- 使用union或者union all时,结果集的列名称取第一个query的命名。
- 如何查询/打印常量(string型)
SELECT '25岁以下' as age_cut,count(*) as number
FROM user_profile WHERE age<25 OR age IS NULL
UNION ALL
SELECT '25岁及以上',count(*)
FROM user_profile WHERE age>=25;
注意2点:
SELECT '25岁以下' as age_cut,count(*) as number
FROM user_profile WHERE age<25 OR age IS NULL
UNION ALL
SELECT '25岁及以上',count(*)
FROM user_profile WHERE age>=25;