![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
qq_22253209
这个作者很懒,什么都没留下…
展开
-
查询第二高薪水,若不存在则返回null
在leetcode上有这样的一道题:查询中第二高的薪水值,不存在则返回nullSELECT (SELECT DISTINCT salary FROM employee GROUP BY salary DESC LIMIT 1,1) AS SECOND或者SELECT ( SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT...原创 2018-06-10 16:03:02 · 3654 阅读 · 2 评论 -
Mysql case when then操作
表数据: 按天分类型统计最近10天的资金总量: SELECT dt,SUM(hold_amt_day), SUM(CASE WHEN `type`=1 THEN hold_amt_day END) AS a1, SUM(CASE WHEN `type`=2 THEN hold_amt_day END) AS a2, SUM(CASE WHEN `type`=3 THEN hold_am...原创 2018-11-09 09:41:02 · 2993 阅读 · 0 评论 -
Spark2 sparkSession使用
sparkSession使用: package com.jdjr.city.demo import org.apache.spark.sql.SparkSession /** * @Auther: hongwei * @Date: 2018/11/9 16:31 * @Description: SparkSession使用 */ object Test4 { def m...原创 2018-11-09 17:00:01 · 1023 阅读 · 0 评论 -
Oracle中导入dmp文件
在Oracle中(scott需要dba权限): imp scott/oracle@orcl11gBigDataTest1 file=/dfs/data/tabledatadmp.dmp full=y buffer=5400000 报错: Import: Release 11.2.0.1.0 - Production on Tue Jan 1 16:23:18 2019 Copyright...原创 2019-01-01 17:56:13 · 2978 阅读 · 0 评论