查找住院,门诊的人数: 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、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
直接上代码: 第一部分: case class OrdPacsresult_obj(pk_dcpv: String, result_obj: String) 第二部分: def ordsubj: Unit = { import sparkSession.implicits._ import spar Read More
第一种方式: def operatorHive: Unit = { Class.forName("org.apache.hive.jdbc.HiveDriver") val url = "jdbc:hive2://192.168.2.xxx:10000" val connection: Connec Read More