查找住院,门诊的人数: SELECT a.leixing,COUNT(a.leixing)FROM(SELECT case resource_type WHEN 'O' THEN '住院'WHEN 'I' THEN '门诊'ELSE '其他' END as leixingFROM `doc_info Read More
1 package com.zjlantone.hive 2 3 import java.util.Properties 4 5 import com.zjlantone.hive.SparkOperaterHive.sparkSession 6 import org.apache.spark.rd Read More
1、mysql语句实现年龄分布select nnd as '年龄段',count(*) as '人数' from( select case when age>=1 and age<=10 then '1-10' when age>=11 and age<=20 then '11-20' when a Read More