摘要:
SQL:sum里加条件SELECT SUM( CASE WHEN "V7010" BETWEEN 0 AND 0.1 THEN 1 ELSE 0 END) FROM "CNYB"."WEA_DAY_CHECK" where "DATE">'12' AND "CODE"='7001' 技巧1 比较运算 阅读全文
摘要:
参考:https://www.cnblogs.com/jonban/p/10779938.html Hive 启动:hive 退出:hive>quit; show databases; use analysis; show tables; desc tab_name; --查看表的结构及表的路径 s 阅读全文