2018年12月28日
case when then else end
查找住院,门诊的人数: 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
posted @ 2018-12-28 17:23 kwz Views(175) Comments(0) Diggs(0)
spark读文件写入mysql(scala版本)
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
posted @ 2018-12-28 16:58 kwz Views(1660) Comments(0) Diggs(0)
mysql语句
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
posted @ 2018-12-28 16:55 kwz Views(469) Comments(0) Diggs(0)